Revision
1. Introduction
Comparisons with NULL
Functions with NULL
COALESCE to the rescue
NULLIF
Revision and practice

Instruction

Welcome to Part 5 of our SQL function course! In this part, we're going to deal with NULLs. We'll talk about how regular functions deal with NULLs and we'll learn functions designed specifically for NULLs.

You're familiar with NULLs already, of course. Here, we want to extend your knowledge so that you're aware of all the conundrums.

Ready, steady… go!

Exercise

Click Next exercise to continue.

Console

Code editor

Result

TableConsole