首页 > 资讯 > SQL Server > 正文

sql查出一张表中重复的所有记录数据的三种方法

18-07-20        来源：[db:作者]  

收藏   我要投稿

select  count(username) as '重复次数',username from xi group by username  having count(*)>1 order by username desc

select * from people
where peopleId in (select  peopleId  from  people  group  by  peopleId  having  count(peopleId) > 1)

select * from people a
where (a.peopleId,a.seq) in  (select peopleId,seq from people group by peopleId,seq  having count(*) > 1)

上一篇：mysql存储过程的使用实例讲解

下一篇：DBCP的配置参数详解（tomcat 的 DHCP的配置）

• 《剑指offer》:[51]数组中的重复数字
• 惊!看世界反毒网如何调试病毒样本!转
• 设计模式总结
• 匹克某站点站多处SQL注入(泄露300w敏感信息/等)