How do we find the duplicate records of a table?

 Posted by Nishithraj on 1/5/2010 | Category: Sql Server Interview questions | Views: 1888

Using the query

SELECT  empname, COUNT(*) AS n FROM employee GROUP BY  empname HAVING COUNT(*)>1

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response