SELECTing Specific Columns - Exercise

Contact Us or call 1-877-932-8228
SELECTing Specific Columns - Exercise

SELECTing Specific Columns

Duration: 5 to 15 minutes.

In this exercise, you will practice selecting specific columns from tables in the Northwind database.

  1. Select CategoryName and Description from the Categories table.
  2. Select ContactName, CompanyName, ContactTitle and Phone from the Customers table.
  3. Select EmployeeID, Title, FirstName, LastName, and Region from the Employees table.
  4. Select RegionID and RegionDescription from the Region table.
  5. Select CompanyName, Fax, Phone and HomePage from the Suppliers table.

Solution:

SimpleSelects/Solutions/SelectCols.sql
SELECT CategoryName, Description
FROM Categories;

SELECT ContactName, CompanyName, ContactTitle, Phone
FROM Customers;

SELECT EmployeeID, Title, FirstName, LastName, Region
FROM Employees;

SELECT RegionID, RegionDescription
FROM Region;

SELECT CompanyName, Fax, Phone, HomePage
FROM Suppliers;
Next