Comparing Missing Values

Learn how to compare NULL values in SQL.


Before we start analyzing data, we usually need to clean it first. Data cleaning is an important part of this process, and handling missing values is a large part of that.

Missing data in SQL

Missing data in SQL is represented by the special value NULL. We already know that some functions, such as aggregate functions, handle NULL values differently. For example:

Create a free account to view this lesson.

By signing up, you agree to Educative's Terms of Service and Privacy Policy