17.10 - search_condition - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

A conditional search expression that must be satisfied by the row set returned by the specified SELECT request.

You cannot specify a SAMPLE clause within a subquery predicate within a WHERE clause.

See Teradata Vantage™ - SQL Data Manipulation Language, B035-1146 for complete documentation of the WHERE clause.