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

 

转载于:https://www.cnblogs.com/suqq/p/10605653.html