how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used

Answer Posted / raghavendraprasad

delete from table_name where rowid not in (select max
(rowid) from table group by duplicate_values_field_name);

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is faster join or subquery?

738


Is like operator in sql case sensitive?

759


Explain clause in sql?

772


Is nosql faster than sql?

769


How to select all records from the table?

840


What sql database should I use?

822


what is auto increment? : Sql dba

778


how is myisam table stored? : Sql dba

800


What is error ora-01000: maximum open cursors exceeded

810


Cite the differences between execution of triggers and stored procedures?

859


Does varchar need length?

727


How do I clear the screen in sql plus?

770


Will truncate release space?

708


what is user defined functions? : Sql dba

775


who introduced sql?

776