Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Creating Basic SQL Reports in SQL Server

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.