Interested to Buy Any Domain ? << Click Here >> for more details...
How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 19075 Views
- HCL, IBM, I also Faced
- E-Mail Answers
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 data locks are respected in oracle?
What is set verify off in oracle?
How to update values on multiple rows in oracle?
what is the use of system.effective.date variable in oracle?
What are the limitations oracle database 10g xe?
How to run the anonymous block again?
How to create an oracle database manually?
What is a read only transaction in oracle?
Explain the use of log option in exp command.
What is a sub query? Describe its types?
Difference between varchar and varchar2 data types?
can u plz provide me oca sql dumps please i need them
How to assign a tablespace to a users in oracle?
How to call a stored function with parameters?
what is the difference between substr and instr function in oracle?
