How to delete identical row from a table?

How to delete identical row from a table?
if we have 4 row and two of them having same data then how we delete identical row using delete query

Showing Answers 1 - 3 of 3 Answers

TRIDIP KUMAR GHOSH

  • Oct 13th, 2011
 

SELECT THE ROWID FROM THE TABLE AND DELETE THE ROWID

e.i.

Code
  1. SELECT rowid FROM table_name WHERE emp_no=9999 AND rate=5000;

  Was this answer useful?  Yes

Siraj

  • Oct 15th, 2011
 

delete from table_name where rowid not in (SELECT max(rowid) FROM table_name group by (column_name))

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