Subqueries | SQL SELECT Statements | VantageCloud Lake - Specifying Subqueries in Search Conditions - Teradata Vantage

Permits a more sophisticated and detailed query of a database through the use of nested SELECT queries.

• IN, NOT IN, ANY, SOME, and ALL Logical Predicate Syntax
• EXISTS Logical Expression Syntax
• Specifying Subqueries in Search Condition Usage Notes
• Subqueries in Search Conditions Examples

ANSI Compliance

Subqueries are ANSI SQL:2011-compliant.