Query to delete duplicate records from a table

Can any one give me the query to delete duplicate records from a table.
not selection of duplicates deletion of duplicate records. sql query only
  • Interview Candidate
  • 3
  • 1424

Showing Answers 1 - 3 of 3 Answers

yeluri

  • Dec 1st, 2006
 

hi guys& gals

         sql>delete from emp where rowid not in(select max(rowid) from emp group by empno);

  Was this answer useful?  Yes

sunil saini

  • Feb 27th, 2007
 

delete from <tabname> where rowid in(select rowid from <tab> group by all column name)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions