How to find only the duplicate records

Satyapriyanayak
Posted by Satyapriyanayak under Sql Server category on | Points: 40 | Views : 721
SELECT name, COUNT(*) AS 'Count'
FROM emp
GROUP BY name having count(*)>1

Comments or Responses

Login to post response