Skip to content

Latest commit

 

History

History
20 lines (15 loc) · 354 Bytes

Count.md

File metadata and controls

20 lines (15 loc) · 354 Bytes
Raw

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;