Interested to Buy Any Domain ? << Click Here >> for more details...
how to find nth highest salary
- 103 Answers
- 179650 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
What are the differences between having and where clause.
List out what other servers you can use with ssrs?
How to create a new table in a given schema?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What is sql server locking?
How to bind a view to the schema of the underlying tables?
Explain mixed authentication mode of sql server?
What is the dbcc command and why is it used?
What is SubQuery in SQL Server 2008
Explain the types of indexes.
How many joins in sql server?
What are the difference between primary keys and foreign keys?
What is merge statement?
How do I find the default sql server instance?
What are the five characteristics of good data?
