distinct去重
select count(distinct(column1))
from 表名
where column3=20210611;
group by去重
select
column1,
count(1)
from
表名
where
column3=20210611
group by
column1;
distinct去重
select count(distinct(column1))
from 表名
where column3=20210611;
group by去重
select
column1,
count(1)
from
表名
where
column3=20210611
group by
column1;