Skip to content

Latest commit

 

History

History
16 lines (13 loc) · 335 Bytes

Distinct.md

File metadata and controls

16 lines (13 loc) · 335 Bytes

Keyword DISTINCT

Is used in combination with SELECT and aggregators.

Syntax:

    SELECT DISTINCT ...
    aggregator (DISTINCT expression)
    SEARCH DISTINCT(selector)

Select distinct values from result array:

    alasql('SELECT DISTINCT MID(Name,1,1) FROM City');

See also: [DISTINCT][Distinct]