Find Duplicate Values in SQL Server
SELECT COLUMN_NAME, COUNT(COLUMN_NAME) AS NumOccurrences
FROM [TABLE_NAME]GROUP
BY COLUMN_NAME
HAVING ( COUNT(COLUMN_NAME) > 1 )
SELECT COLUMN_NAME, COUNT(COLUMN_NAME) AS NumOccurrences
FROM [TABLE_NAME]GROUP
BY COLUMN_NAME
HAVING ( COUNT(COLUMN_NAME) > 1 )
No comments:
Post a Comment