Interested to Buy Any Domain ? << Click Here >> for more details...
Delete duplicate records in the emp table.
- 6 Answers
- 14812 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
Why join is faster than subquery?
Is sql the best database?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Explain the difference in execution of triggers and stored procedures?
Is subquery faster than join?
Which one is faster ienumerable or iqueryable?
How much does sql certification cost?
How do I view an execution plan in sql?
Explain dml and ddl?
What is raid? How does it help storage of databases?
What does pl sql stand for?
what are the 'mysql' command line arguments? : Sql dba
How does cross join work?
What's the procedure?
Write a sql query to get the third highest salary of an employee from employee_table?
