SELECT sal FROM ( SELECT DENSE_RANK() OVER (ORDER BY sal DESC) AS ran

how to find nth highest salary

Question Posted / sitakanta rath

Answer Posted / sitakanta rath

SELECT sal FROM
(
SELECT DENSE_RANK() OVER (ORDER BY sal DESC) AS rank, sal
FROM Emp
) T2
WHERE rank=@n

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How you can get a list of all the table constraints in a database? : Sql server administration

1030

what are the different stages of Report Processing?

135

What are the different authentication modes in sql server? How can it be changed?

1097

What are views in ms sql server?

1092

How to delete duplicate rows in sql server?

1113

What is TDS(Tabular Data Stream) Gateway?

121

What is the fillfactor concept in indexes?

990

List the data types available in mssql?

1038

Explain the difference between clustered and non-clustered index?

928

How to execute a sql statement using odbc_exec()?

1151

what is raid and what are different types of raid configurations? : Sql server database administration

1050

What are different types of raid configurations? : SQL Server Architecture

1087

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1151

How many categories of data types used by sql server?

1023

What is default port number for sql server 2000?

1058