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

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Searching for Nulls Using a SELECT Request

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.