Delete duplicate records in the emp table.
- 6 Answers
- 13693 Views
- Oracle, I also Faced
- E-Mail Answers
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 has stored procedures in sql?
Is postgresql a server?
What are different types of triggers?
What is indexing oracle sql?
What is a sql*loader control file?
What is string data type in sql?
Which certification is best for sql?
Why primary key is required?
What is cursor and its types?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Can we have two clustered index on a table?
How many types of triggers exist in pl/sql?
What is the difference between distinct and unique in sql?
define sql update statement ? : Sql dba
Why do we use view in sql?
