how to find nth highest salary
Answer Posted / anand patel.
It is a very generic and easy way to find the Nth higest
salary with there employee/s name.
select * from emp where salary =
(select max(salary) from emp where salary in
(select top (select (count(*)-(n-1))from emp) salary
from emp order by salary))
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is the difference between writing data to mirrored drives versus raid5 drives
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
Explain what are sparse columns?
What is the simplest way to create a new database in ms sql server?
explain what is raid and what are different types of raid configurations? : Sql server database administration
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
You want to implement the one-to-many relationship while designing tables. How would you do it?
What is the largest component inside a field?
what are the different ways to return the rowcount of a table?
Explain the flow of creating a cube? : sql server analysis services, ssas
How do I create a stored procedure in sql server?
What is normalization? Describe its different types.
Is t sql the same as sql server?
Can you explain different types of joins?
Is sql server difficult to learn?