DISTINCT

This section contains reference documentation for the DISTINCT function.

Returns the distinct row values in a group

Signature

DISTINCT(colName)

Usage Examples

These examples are based on the Batch Quick Start.

select DISTINCT league AS value
from baseballStats 

value
NL
UA
AL
NA
PL
AA
FL

select DISTINCT(league) AS value
from baseballStats 

value
NL
UA
AL
NA
PL
AA
FL