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
What is faster join or subquery?
Is like operator in sql case sensitive?
Explain clause in sql?
Is nosql faster than sql?
How to select all records from the table?
What sql database should I use?
what is auto increment? : Sql dba
how is myisam table stored? : Sql dba
What is error ora-01000: maximum open cursors exceeded
Cite the differences between execution of triggers and stored procedures?
Does varchar need length?
How do I clear the screen in sql plus?
Will truncate release space?
what is user defined functions? : Sql dba
who introduced sql?