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
What are the events on which a database trigger can be based?
How is a process of pl/sql compiled?
What are the two types of cursors in pl sql?
In what condition is it good to disable a trigger?
Explain lock escalation? : Transact sql
What is the usage of distinct keyword?
what is the difference between blob and text? : Sql dba
How many commands are there in sql?
how would you get the current date in mysql? : Sql dba
how to rename an existing table in mysql? : Sql dba
what is myisam? : Sql dba
What are the benefits of stored procedures?
What is nvarchar max in sql?
Does sql require a server?
what is the syntax used for partition in tsql? : Transact sql