Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Help On Query RE: Help On Query
Koen Verbeeck
SSC Guru
Points: 259085
More actions
September 10, 2013 at 12:59 am
#1648726
This should do the trick:
SELECT Name
FROM SAMPLE
GROUP BY Name
HAVING COUNT(*) > 1;
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP