17.10 - Searching for Nulls Using a SELECT Request - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
kko1591750222108.ditamap
dita:ditavalPath
kko1591750222108.ditaval

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.