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
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
vnq1596660420420.ditamap
dita:ditavalPath
hoy1596145193032.ditaval

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.