declare @n; set @n = N select * from tbl where @n in ( select dense

how to find nth highest salary

Question Posted / avinash

Answer Posted / avinash

declare @n;
set @n = N
select * from tbl
where @n in (
select dense_rank over (order by salary) as rank_sal
from tbl )

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the basic functions for master, msdb, model, tempdb databases?

1098

When you should use a low fill factor?

1042

What is rtm version in sql server?

1110

What is entity data services?

1117

How to find the login name linked to a given user name?

1062

How to check parameter value in stored procedure sql server?

1035

List the different types of collation sensitivities in sql server?

1081

List the various tools available for performance tuning?

929

What do you understand by mirroring and mention the advantages of the mirroring?

1120

What are the disadvantages of using querystrings to send data from one page to another?

1077

What is meant by referential integrity?

1050

what is difference between NULL and ISNULL in SQL Server 2008?

1058

What is an indexing technique?

988

What is user-defined function?

1035

What is exporting utility?

1091