16.10 - Searching for Nulls Using a SELECT Request - Teradata Database

Teradata Database Design

Teradata Database
Release Number
Release Date
June 2017
Content Type
User Guide
Publication ID
English (United States)

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, you could type the following request.

     SELECT name
     FROM employee
     WHERE dept_no IS NULL;

This query produces the names of all employees having a null in the dept_no column. Because all employees contained in the employee table have been assigned to a department, no rows would be returned for this particular example.