EXISTS/NOT EXISTS Predicates | VantageCloud Lake - EXISTS/NOT EXISTS - Teradata VantageCloud Lake

Tests a specified table (typically a derived table) for the existence of at least one row (that is, tests whether the table in question is non-empty).

EXISTS is supported as the predicate of the search condition in a WHERE clause.

• EXISTS/NOT EXISTS Predicate Syntax
• EXISTS/NOT EXISTS Usage Notes
• EXISTS/NOT EXISTS Examples

ANSI Compliance

This statement is ANSI SQL:2011 compliant.