Table 139. Qualify Function
Field | Description |
|---|---|
Description | Filters results of a previously computed OLAP function according to user-specified conditions. |
Syntax: | Qualify search_condition |
Qualify | Represents a conditional clause in the SELECT statement. |
search_condition | One or more conditional expressions that must be satisfied by the result rows. Aggregate operators with a Qualify clause can be used. |
Usage Notes | When you specify a QUALIFY clause in a query, you must also specify a statistical function in one of the following locations within the query. select_list of the SELECT clause grouping_key of the GROUP BY clause search_condition of the QUALIFY clause When the WHERE, GROUP BY, and QUALIFY clauses are used together in a SELECT statement, the order of evaluation is: WHERE GROUP BY QUALIFY |