select count(1),count(id),count(distinct id) from
(select 1 as id
union all
select 1 as id
union all
select 2 as id
union all
select null as id
) a;
count(1),count(id),count(distinct id)的不同
最新推荐文章于 2021-12-20 10:59:01 发布
select count(1),count(id),count(distinct id) from
(select 1 as id
union all
select 1 as id
union all
select 2 as id
union all
select null as id
) a;