QUALIFY Clause Syntax | SQL SELECT Statements | Teradata Vantage - QUALIFY Clause Syntax - Analytics Database - Teradata Vantage
SQL Data Manipulation Language
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 17.20
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2025-04-02
- dita:mapPath
- pon1628111750298.ditamap
- dita:ditavalPath
- qkf1628213546010.ditaval
- dita:id
- esx1472246586715
- lifecycle
- latest
- Product Category
- Teradata Vantage™
Syntax Elements
- search_condition
- One or more conditional expressions that must be satisfied by the result rows.
- You can specify ordered analytical functions and scalar subqueries as search conditions with QUALIFY.
- You can use aggregate operators and DEFAULT functions within a QUALIFY search condition.
- The QUALIFY condition cannot reference LOB columns.
- If you specify the value for a row-level security constraint in a search condition, that value must be expressed in its encoded form.