kldesigns
5/27/2019 - 5:11 AM

Duplicates in a column SQL

SELECT [First Name], COUNT([First Name]) 
FROM [PeopleConnect_Data_Migration].[dbo].[PC-DET 1]
GROUP BY [First Name]
HAVING COUNT([First Name]) > 1