find out the third highest salary?
- 92 Answers
- 129082 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / amrish singh
this is the query for retrieving nth highest salary from
table emp
select e.sal
from emp e
where n-1=(select count(*) from emp s where s.sal>e.sal)
putting the value of n we get the required result.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to create a stored procedure in oracle?
defination of bitmap index
How to execute the package in oracle?
What are internal user account in oracle?
How to assign a tablespace to a users in oracle?
How to login to the server without an instance?
What is a user role in oracle?
How to create a temporary table in oracle?
How do you bind variables in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to update values on multiple rows in oracle?
How to rename a tablespace in oracle?
What is a table in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Explain about your project and its relation to the current job position you are applying to?
