How do we find the duplicate records of a table?

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

Answer:

Using the query

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

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How do we find the last date of current month?

Next > : How do we convert money to character?

More Interview Questions by Nishithraj

Latest Interview Questions