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
How to load excel data sheet to oracle database
How to convert characters to dates in oracle?
Explain what are the characteristics of data files?
Is postgres faster than oracle?
What are triggers in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Is there a combination of "like" and "in" in sql?
What are internal user account in oracle?
In the oracle version 9.3.0.5.0, what does each number shows?
Differentiate between pre-select and pre-query?
What happens to the current transaction if a ddl statement is executed?
How to turn on or off recycle bin for the instance?
What is the usage of save points in oracle database?
How to start your 10g xe server from command line?
What is truncate oracle?