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
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What are a collation and state the different types of collation sensitivity?
What is oracle in java?
Explain the use of grant option in exp command.
What is catalog in Oracle?
What are the limitations oracle database 10g xe?
 What are the oracle DML commands possible through an update strategy?
How many memory layers are in the oracle shared pool?
How to execute a stored procedure in oracle?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
Is there an oracle sql query that aggregates multiple rows into one row?
What is a user role in oracle?
What is logical backup in oracle?
What are the different types of failures that occur in Oracle database?
Can we create database in oracle using command line ?