SQL IS NULL Operator

A column value is NULL if it does not exist. The IS NULL operator is used to display all the rows for columns that do not have a value.

For Example: If you want to find the names of students who do not participate in any games, the query would be as given below

SELECT first_name, last_name
FROM student_details
WHERE games IS NULL 

There would be no output as we have every student participate in a game in the table student_details, else the names of the students who do not participate in any games would be displayed.