sql server 查询表A中某字段出现3次以上重复的记录
1.查询表A中ID出现3次以上重复的记录
SELECT * FROM T_DesignReply WHERE Dr_ProjectNumber IN
(
SELECT Dr_ProjectNumber FROM T_DesignReply GROUP BY Dr_ProjectNumber HAVING count(Dr_ProjectNumber)>3
)
==》Select *From A Where id in(select ID from A group by id having count(id)>3)
2.查询表A中IName出现3次以上重复的记录
Select * From A Where Name in(select Name from A group by Name having count(Name)>3