sql server显示某一列中有重复值的行
sql server查询一张表 ,显示某一列中有重复值的行,可以这样写:
Select * From 表名 where 列名 in(Select 列名 From 表名 group by 列名 having count(*)>1)
比如:
SELECT*FROM dbo.CGHTH WHERE XQLX IN(SELECT XQLX FROM dbo.CGHTH GROUP BY XQLX HAVING COUNT(*)>1)
[转载来源:](https://www.cnblogs.com/527289276qq/p/5746504.html)