例子如下:
-- sql
select uniq(device_id)
from com_vv_binguo
WHERE toDate(time_stamp) >= '2021-12-20' and event_name = '启动';
-- sql2
-- ps:uniqIf是在where之后执行的,所以性能会差
select
例子如下:
-- sql
select uniq(device_id)
from com_vv_binguo
WHERE toDate(time_stamp) >= '2021-12-20' and event_name = '启动';
-- sql2
-- ps:uniqIf是在where之后执行的,所以性能会差
select