select count(*) as U from (select count(*) as c from test.user group by b)as t where t.c >=2;
select count(*) from (select count(*) from test.`user` group by b having count(*)>=2) as t ;
从数据库里查重复的记录大于2的记录个数
最新推荐文章于 2022-09-30 12:36:27 发布
select count(*) as U from (select count(*) as c from test.user group by b)as t where t.c >=2;
select count(*) from (select count(*) from test.`user` group by b having count(*)>=2) as t ;