Delete duplicate records in the emp table.
Answer Posted / amedela chandra sekhar
delete from emp x where rowid>(select min(rowid) from emp
where rmpno=x.empno);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are types of indexes in sql?
What is a recursive stored procedure?
What is the benefit of foreign key?
When should I use nosql database?
What is difference between pl and sql?
Mention what is the use of function "module procedure" in pl/sql?
explain the delete statements in sql
Determine if oracle date is on a weekend?
How to read xml file in oracle pl sql?
Define concurrency control. : Transact sql
What is substitution variable in pl sql?
is it possible to pass an object or table to a procedure as an argument?
what are the nonstandard string types? : Sql dba
Why truncate is used in sql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba