Checking for NULL
Duration: 5 to 15 minutes.
In this exercise, you will practice selecting records with fields that have
- Create a report that shows the company name, contact name and fax number of all customers that have a fax number.
- Create a report that shows the first and last name of all employees who do not report to anybody.
SELECT CompanyName, ContactName, Fax
WHERE Fax IS NOT NULL;
SELECT FirstName, LastName
WHERE ReportsTo IS NULL;