Count
Mathias Rangel Wulff edited this page Jun 12, 2015
·
3 revisions
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;
© 2014-2023, Andrey Gershun & Mathias Rangel Wulff
Please let us know if something could be described better by submitting an issue