Purpose
A conditional clause in the SELECT statement that filters results of a previously computed ordered analytical function according to user-specified search conditions.
Syntax
Syntax Elements
- QUALIFY
- An introduction to a conditional clause that, similar to HAVING, further filters rows from a WHERE clause. The major difference between QUALIFY and HAVING is that with QUALIFY the filtering is based on the result of performing various ordered analytical functions on the data.
- search_condition
- One or more conditional expressions that must be satisfied by the result rows.
ANSI Compliance
The QUALIFY clause is a Teradata extension to the ANSI standard.
Related Topics
For more information related to the QUALIFY clause, see: