-
distinct
select count(distinct uid)
from tableName
where date = '2021-12-27';
-
group by
select count(uid)
from (
select uid
from tableName
where date = '2021-12-27'
group by uid);
-
uniqExact
select uniqExact(uid)
from tableName
where date = '2021-12-27';