how to find nth highest salary
- 103 Answers
- 163905 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
Answer Posted / ankur bakliwal
I think this should work -
select top 1 salary from employee where salary in (select
distinct
top n salary from employee order by salary desc) order by
salary asc
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
What is transaction server auto commit?
Why do we use stored procedures in sql server?
why would you call update statistics? : Sql server database administration
Explain triggers in sql?
What is the filtered index?
What do you mean by sql server agent?
What is SQL Azure Firewall?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What is a rollup clause?
What are commit and rollback in sql?
What is side by side migration in sql server?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Is the primary key column of a table an index in ms sql server?
User wants only to display only pdf as export option in report manager. How to achieve this?
