SQL SERVER – Count Duplicate Records – Rows

分类: IT文章 • 2023-10-29 13:10:25

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