how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
- 11 Answers
- 15832 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / jas
delete from table_name where rowid > (select min(rowid)
from table_name where a.col_name=b.col_name)
create new_table as select distinct * from table_name;
drop table_name;
create table_name as select * from new_table;
drop new_table;
delete from table_name where rowid not in (select max
(rowid) from table_name where a.col_name=b.col_name)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is delete faster than truncate?
How to make a copy values from one column to another in sql?
What is the difference between explicit and implicit cursors in oracle?
What are different methods to trace the pl/sql code?
Is sql harder than python?
What is a left join?
What is not equal in sql?
What are some emotional triggers?
Is subquery faster than join?
How does postgresql compare to oracle/db2/ms sql server/informix?
How do I install sql?
What is thread join () in threading?
when is the use of update_statistics command? : Sql dba
What packages are available to pl/sql developers?
explain what is mysql? : Sql dba
