Delete duplicate records in the emp table.
- 6 Answers
- 13372 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 many functions are there in sql?
What is use of trigger?
What is sqlca in powerbuilder?
What is the use of & in pl sql?
Explain dml and ddl?
What are primary key and foreign key and how they work?
What do we need to check in database testing?
Show the two pl/sql cursor exceptions.
What is sql rowcount?
How to return multiple rows from the stored procedure?
What is the difference between inner join and natural join?
What is parallel hint?
Why left join is used in sql?
What is sql procedures and functions?
define sql delete statement ? : Sql dba
