Loading

SQL SERVER – Count Duplicate Records – Rows

SELECT YourColumn, COUNT(*) TotalCount
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC

 

http://blog.sqlauthority.com/2007/07/11/sql-server-count-duplicate-records-rows/

 

posted @ 2013-11-11 16:41  .net's  阅读(653)  评论(0)  编辑  收藏  举报