DISTINCT Option - Teradata Vantage - Analytics Database

SQL Functions, Expressions, and Predicates

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-03-30
dita:mapPath
obm1628111499646.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
kby1472250656485
lifecycle
latest
Product Category
Teradata Vantageā„¢

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;