Rainbow Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Get to know the database
3. The Employees table
Summary

Instruction

Let's start with the Employees table.

It stores information about the people employed at Northwind. Each employee has:

  • A unique ID (EmployeeID).
  • A first and last name (FirstName and LastName).
  • A professional title (Title).

Pay attention to the column named ReportsTo, which contains the employee ID (from the same table) of the employee's manager. There are also other informative columns in this table, such as HireDate and Address.

Exercise

Select all the information from the Employees table.

Stuck? Here's a hint!

Use an asterisk (*) to select all columns.