Interested to Buy Any Domain ? << Click Here >> for more details...
How to Remove the 3rd highest salary person record from
table?
- 9 Answers
- 19366 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
What are the uses of linked server and explain it in detail?
How to drop an index?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What are the types of trigger in oracle?
How to change system global area (sga) in oracle?
How to count groups returned with the group by clause in oracle?
What do you mean by merge in oracle and how can you merge two tables?
How do I spool to a csv formatted file using sqlplus?
how can we store any pdf file in oracle
What is save point in oracle database?
Explain about the analyze command in oracle?
What is the quickest way to export a table to a flat file?
What are a cluster and non-cluster index?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is bulk copy or bcp in oracle?
