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 is cte (common table expression)?

1039

Can a database be shrunk to 0 bytes, if not, why?

1111

Do you know what is difference between stored procedure and user defined function?

1099

What is the difference between system objects and user objects?

1168

What is difference between joins and subqueries?

1126

What are different types of collation sensitivity?

990

What is an index in sql?

1013

Tell me what are the essential components of sql server service broker?

945

Does sql server use t sql?

1029

Where actually sql azure database is hosted?

163

Do you know how to send email from database?

1013

When do you think a developer should use sql server-based cursors?

1052

What does indexation mean?

982

What is difference between temp table and cte?

1030

What is the security model used in sql server 2005?

1015