find out the third highest salary?
- 92 Answers
- 129052 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / venkatranjith e
Hi All,
This query will give you the o/p.
Select * from EMP A where &n= (select count (distinct
(sal)) from EMP B where B.sal>A.sal)
n = 3 , to display 3rd largest salary.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is a directory object?
What is an oracle and why it is used?
How to return top 5 rows in oracle?
Explain temporal data types in oracle
What is integrity and what is constraint??Explain with example
How to start instance with a minimal initialization parameter file?
What are the uses of a database trigger?
Can you tell me how to add new column in existing views?how?How is possible?
What are privileges and grants?
How to do a full database export?
What is the fastest query method to fetch data from the table?
What are the different types of partitions in oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How to do paging with oracle?
various types of hints and their usage
