常用SQL集锦 好记性不如烂博客

1、查询出 某字段有值重复的记录（单个字段）

select * from 表 t where (t.username) in (select username from 表 group by username having count(*) > 1)

2、查找表中多余的重复记录（多个字段） 

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