Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 147646 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / ashok naik
In Sql server:
Select top 1 ThirdHighest.salary from(
Select distinct top 3 salary from employee order by salary
desc) as ThirdHighest
--example for 4th highest salary in above query put 4
inplace of 3
--example for 5th highest salary in above query put 5
inplace of 3
--and so on for nth highest
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can objects of the same schema reside in different tablespace?
What are nested tables?
How to rename an index in oracle?
How to use subqueries in the from clause in oracle?
what is port in oracle? how is it related to database application.
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is oracle and what are its different editions?
How to find the duplicate rows count from employees table in oracle?
What is snapshot is too old? Give and example for better understand.
Can select statements be used on views in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
what is the difference between functional dependecy and multilevel dependency?
What is a directory object?
What is data block in Oracle?
How to view the tablespaces in the current database?
