Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151209 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / punit chauhan
select * from emp_record e1 where (3-1) = (select count ( distinct (e2.salary)) from emp_record e2 where e2.salary > e1.salary
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What privilege is needed for a user to delete rows from tables in another schema?
How do I spool in oracle?
How to list all indexes in your schema?
How to manage transaction isolation level?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Why does Oracle not permit the use of PCTUSED with indexes?
What are a cluster and non-cluster index?
How to write a left outer join with the where clause in oracle?
How to write date and time interval literals in oracle?
How to delete a column in an existing table?
How to invoke the original export import utilities?
What does sharding mean?
What is difference between truncate and delete?
How to rename a column in an existing table?
How to export several tables together?
