Count

Keyword COUNT

Summing aggregator.

Syntax:

    COUNT([DISTINCT] expression | *)

AlaSQL supports COUNT() aggregator:

    SELECT COUNT(*) FROM one;
    SELECT COUNT(a) FROM one;

Also you can use COUNT() with DISTINCT keyword to count all non repeated values:

    SELECT COUNT(DISTINCT a) FROM one;