Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 151320 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 declare a local variable?
What is an oracle recycle bin?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Why we use bulk collect in oracle?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What is an anonymous block?
What's dateware house and what's clustor with practicle example
How to convert times to characters in oracle?
How to create a temporary table in oracle?
How to define an external table with a text file?
What are set operators?
What is meant by joins?
Can we create database in oracle using command line ?
How to execute a stored program unit?
Explain the features of oracle?
