SQL SERVER – Find out the Duplicate Records

SELECT AccNo, COUNT(*) TotalCount
FROM SRLibData
GROUP BY AccNo
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC

Thanks
Alok Kumar Sharma