How to Remove the 3rd highest salary person record from
table?
Answer Posted / suresh babu
delete from employees where employee_id in (select
employee_id from employees where 3 =(select count(distinct
e.salary) from employees e
where e.salary >= employees.salary));
Is This Answer Correct ? | 17 Yes | 1 No |
Post New Answer View All Answers
Can group functions be used in the order by clause in oracle?
What is proxy method?
What is the meaning of recursive hints in oracle?
How to define an oracle cursor variable?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How remove data files before opening a database?
Is oracle a programming language?
why dont we assign not null constraint as table level constraint.
How many types of auditing in Oracle?
What is columnar storage what is the advantage?
What is bulk load in oracle?
Explain oracle 12c new features for developers?
Are truncate and delete commands same? If so why?
How view is different from a table?
What do you mean by cdb and pdb in oracle 12c?