Go homepage(回首页)
Upload pictures (上传图片)
Write articles (发文字帖)

The author:(作者)归海一刀
published in(发表于) 2014/2/1 0:21:12
找出数据库表里重复记录和重复记录数的SQL_[SQL，Server教程]

SELECT COUNT(*) AS RowNumber,COL1,COL2
FROM TABLE1 T1
WHERE
(SELECT COUNT(*)
FROM TABLE1 T2
WHERE T1.COL1 = T2.COL1 AND T1.COL2 = T2.COL2)>1
GROUP BY COL1,COL2

赞