17.05 - Distincts and Multiple Aggregate Distincts - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

Vantage supports the use of:

  • One DISTINCT expression when performing an aggregation.
  • Multiple aggregate distincts, which allow multiple DISTINCT expressions for aggregates.

    For example:

    SELECT g, SUM(DISTINCT a), SUM(DISTINCT b)
    FROM T
    GROUP BY g
    COUNT(DISTINCT c) > 5;

    The feature simplifies SQL generation.