how to find nth highest salary
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 are the steps you will take to improve the performance of a poor performing query?
Tell me the phases a transaction has to undergo?
How to turn on the mssql api module in php?
What is normalization and denormalization in sql server?
Give a example to search fr a string in all stored procedure in sql server.
What is ssl in sql server?
Can two tables share the same primary key?
List the types of recovery model available in sql server?
How to add more data to the testing table in ms sql server?
Mention the uses of stored procedures.
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
How to apply filtering criteria at group level with the having clause in ms sql server?
What are the common performance issues in sql server?
How and why use sql server?
How to get a list of all tables with "sys.tables" view in ms sql server?