从数据库里查重复的记录大于2的记录个数

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 ;

阅读更多
文章标签: 数据库
个人分类: 数据库
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭
关闭