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
Comparisons with NULL
10. Never trust a NULL
Functions with NULL
COALESCE to the rescue
NULLIF
Review and practice

Instruction

Good! As you can see, you need to keep your eyes open when you work with NULLs in your WHERE statements.

Remember – every time, think whether some columns can be NULLs. If they can, modify your query a tiny bit, just as we did in this section.

Exercise

Click Next exercise to continue.