how to find nth highest salary
- 103 Answers
- 158657 Views
- Cognizant, IBM, NexGen, Oracle, I also Faced
- E-Mail Answers
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
Differentiate between a having clause and a where clause.
Explain triggers in sql?
why would you call update statistics? : Sql server database administration
What is the difference between osql and query analyzer?
What is the maximum size of sql server database?
What is analysis service repository?
What is entity data services?
Can we use max in where clause?
Does a server store data?
what is package and it uses and how can u call a package
What are cursors in ms sql server?
How many columns can we include on clustered index ?
What do you need to connect php to sql server?
Can an automatic recovery be initiated by a user?
What are the properties of the transactions?
