Exploring the Tables - Exercise

Contact Us or call 1-877-932-8228
Exploring the Tables - Exercise

Exploring the Tables

Duration: 10 to 20 minutes.

In this exercise, you will explore all the data in the Northwind database by selecting all the rows of each of the tables.

  1. Using your SQL editor, execute the necessary SQL queries to select all columns of all rows from the tables below.
  2. The number of records that should be returned is indicated in parentheses next to the table name.
    1. Categories (8)
    2. Customers (91)
    3. Employees (9)
    4. Orders (830)
    5. Products (81)
    6. Shippers (3)
    7. Suppliers (29)

Solution:

SimpleSelects/Solutions/SelectAll.sql
SELECT * FROM Categories;
SELECT * FROM Customers;
SELECT * FROM Employees;
SELECT * FROM Orders;
SELECT * FROM Products;
SELECT * FROM Shippers;
SELECT * FROM Suppliers;
Next