17.10 - Aggregates in WHERE and HAVING Clauses - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

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

Aggregates can appear in the following types of clauses:

  • The WHERE clause of an ABORT statement to specify an abort condition.

    But an aggregate function cannot appear in the WHERE clause of a SELECT statement.

  • A HAVING clause to specify a group condition.