A conditional clause in the SELECT statement that filters results of a previously computed ordered analytical function according to user-specified search conditions.
The major difference between QUALIFY and HAVING is that with QUALIFY the filtering is based on the result of performing ordered analytical functions on the data.
ANSI Compliance
The QUALIFY clause is a Teradata extension to the ANSI standard.