Apache Pinot Docs
latest
Search…
⌃K

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