Searching for Nulls Using a SELECT Request - Teradata VantageCloud Lake

The IS NULL operator tests for the presence of nulls in a specified column. For example, to search for the names of all employees who have a null in the dept_no column, enter the following request.

     SELECT name
     FROM employee
     WHERE dept_no IS NULL;

This query returns the names of all employees with null in the dept_no column. Because all employees in the employee table were assigned to a department, the request returns no rows.