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

Standard SQL Functions

Review
2. Get to know the table
Comparisons with NULL
Functions with NULL
COALESCE to the rescue
NULLIF
Review and practice

Instruction

All right. Before we start, we'll introduce our today's guest: Mr. Adams. He is CEO for Highland Furniture. – a company which sells furniture and home accessories. He's agreed to show us a snippet of his product table. Let's see what's in there before we move on.

Exercise

Select all columns for the table product and study the contents.

Stuck? Here's a hint!

Use * to select all columns.