Delete duplicate records in the emp table.
- 6 Answers
- 13703 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / valli
delete from emp where rowid in(
select rowid from (
select emp_no, sal,rownum() over (emp_no,sal) as
Rownum from emp order_by emp_no,sal
) where rownum > 2
)
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
How to use sql*plus built-in timers?
What is the benefit of foreign key?
What type of database is sql?
Does oracle roll back the transaction on an error?
Does sql profiler affect performance?
How do I run a sql query in pgadmin 4?
How can you load multi line records? : aql loader
What is sql character function?
What are the advantages of pl sql over sql?
Why is pl sql needed?
What is the most restrictive isolation level? : Transact sql
How to find 3rd highest salary of an employee from the employee table in sql?
Can I learn sql in a week?
what are different types of collation sensitivity? : Sql dba
Why truncate is faster than delete?
