Distinct

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]