Saturday, April 21, 2012
SQL SERVER – Count Duplicate Records – Rows
SELECT
YourColumn
,
COUNT
(*)
TotalCount
FROM
YourTable
GROUP
BY
YourColumn
HAVING
COUNT
(*)
>
1
ORDER
BY
COUNT
(*)
DESC
Newer Post
Home