Distinct

DISTINCT

Keyword for 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()][Search Distinct]