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 / 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
Which is faster subquery or join?
What is difference between pl and sql?
What are different types of triggers?
What is primary key secondary key alternate key candidate key?
What is sorting in sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
How do you select unique values in sql?
What is the difference between a query and a report?
What is count * in sql?
Is sqlexception checked or unchecked?
Determine if oracle date is on a weekend?
what are the advantages of sql ? : Sql dba
How does a trigger work?
How do I run a program in pl sql?
Can you sum a count in sql?