Tables referenced in a QUALIFY clause must be specified in one of the following:
- FROM clause
- WHERE clause
- SELECT expression list
- Non-aggregate condition
Otherwise, the system returns an error to the requestor. QUALIFY is similar to HAVING in that rows are eliminated based on the value of a function computation. With QUALIFY, rows are eliminated based on the computation of the ordered analytical functions.