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