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 / dinesh mohan upadhyay
delete from emp
where rowid>any(select min(rowid) from emp a where
a.col1=col1)
Is This Answer Correct ? | 15 Yes | 8 No |
Post New Answer View All Answers
Is pl sql a scripting language?
How to run pl/sql statements in sql*plus?
Enlist the advantages of sql.
How do I run a pl sql program?
In a distributed database system, can we execute two queries simultaneously?
What are the different ways to optimize a sql query?
What are the different types of dbmss?
Can we use joins in subquery?
What is rowid in sql?
what does it mean to have quoted_identifier on? : Sql dba
Can we create foreign key without primary key?
How do I view a view in sql?
What is output spooling in sql*plus?
Can we change the table name in sql?
Is sql free?