WHERE Clause | SQL SELECT Statements | Teradata Vantage - WHERE Clause - Analytics Database - Teradata Vantage

Filters rows that satisfy a conditional expression in SELECT, DELETE, INSERT, UPDATE, ABORT, and ROLLBACK statements.

Vantage uses WHERE clause conditions on actual or virtual partition columns to optimize path filters.

ANSI Compliance

The WHERE clause is ANSI SQL:2011-compliant.