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 invoke the original export import utilities?
Please explain oracle data types with examples?
What is an oracle database table?
How to use subqueries with the in operator using oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is ASM (Automatic Storage Management) in Oracle?
What is a sub query? What are its various types?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
various types of hints and their usage
What is max rowid in oracle?
How to add another datafile to a tablespace?
What are the uses of linked server and explain it in detail?
What is tns entry?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Explain what are the advantages of views?