17.00 - 17.05 - DISTINCT Option - Advanced SQL Engine - Teradata Database

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-30
dita:mapPath
tpt1555966086716.ditamap
dita:ditavalPath
lze1555437562152.ditaval

The DISTINCT option specifies that duplicate values are not to be used when an expression is processed.

The following SELECT returns the number of unique job titles in a table.

   SELECT COUNT(DISTINCT JobTitle) FROM Employee;

A query can have multiple aggregate functions that use DISTINCT with the same expression, as shown by the following example.

   SELECT SUM(DISTINCT x), AVG(DISTINCT x) FROM XTable;

A query can also have multiple aggregate functions that use DISTINCT with different expressions, for example:

   SELECT SUM(DISTINCT x), SUM(DISTINCT y) FROM XYTable;