17.10 - Excluding Nulls From Query Results - 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 NOT NULL operator excludes rows having a null in a specified column from the results of a query.

For example, to search for the names of all employees with non-nulls in the job_title column, you could type the following request.

     SELECT name
     FROM employee
     WHERE job_title IS NOT NULL;

The result of this query is the names of all employees with a non-null in the job_title column. For this particular example, the names of all employees are returned because every employee has, by definition, been assigned a job title.