Introduction
2. The Employee table
INSERT with SELECT
Referring to other tables
INSERT, UPDATE and DELETE with JOIN
INSERT, UPDATE, and DELETE with subqueries
Summary

Instruction

We'll start with the Employee table, which stores information about the employees who sell products to customers.

Exercise

Select all columns from the Employee table. This table has the following columns:

  • Id – identifies each employee.
  • FirstName – the first name of the employee.
  • LastName – the last name of the employee.
  • Salary – the employee's salary.