SQL 列出某列有重复的记录

select * from ReportCustomMission where ProjectCode in (select ProjectCode from ReportCustomMission group by ProjectCode having(count(*) > 1))

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/jxgxy/p/2636785.html