2 ms·
You don't have to write `count()` in ClickHouse - `count(*)` is also ok. ... while `count()` makes more sense from the engineering perspective: it is an aggreg
by zX41ZdbW 2y ago
You don't have to write `count()` in ClickHouse - `count(*)` is also ok.
... while `count()` makes more sense from the engineering perspective: it is an aggregate function that takes zero number of arguments.
I personally prefer `count()`, but when my friends write `count(*)` or even `COUNT(*)`, they are still my friends.
- hodgesrm 2y agoThe count() invocation is a small but excellent feature in ClickHouse. There are many other great dialect extensions. -If combinators are another great example. [0] SQL would be a better language if there had been more innovation focused on code usability over its long history. [0] https://clickhouse.com/docs/en/sql-reference/aggregate-functions/combinators#-if https://clickhouse.com/docs/en/sql-reference/aggregate-funct...