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

Teradata Database Design

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
User Guide
Publication ID
B035-1094-161K
Language
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.