distinct

Returns unique rows from the input, removing duplicates across the specified columns.

Spec

... | distinct <column> [, ...]

Parameters

column - One or more columns to determine uniqueness.

Return Value

A table with duplicate rows removed based on the specified columns.

Example

datatable(City:string, Country:string)
[
    "Seattle", "US",
    "Portland", "US",
    "Seattle", "US",
    "Vancouver", "CA"
]
| distinct City, Country

City	Country
Seattle	US
Portland	US
Vancouver	CA