SELECT TOP Nth salary FROM ( SELECT TOP N salary FROM emp O

how to find nth highest salary

Question Posted / suhail qaiser

Answer Posted / suhail qaiser

SELECT TOP Nth salary
FROM (
SELECT TOP N salary
FROM emp
ORDER BY salary DESC
) TmpTable
ORDER BY salary ASC

Is This Answer Correct ?

38 Yes

56 No

Please Help Members By Posting Answers For Below Questions

What is mean by dml?

969

what stored procedure can you use to display the current processes? : Sql server administration

978

ow to bring suspect mode datbase online from scratch

1782

What do you know about system database? : SQL Server Architecture

950

How do I view a trc file?

919

What is sql server profiler?

973

What is user-defined multi-statement table-valued function?

1021

can you instantiate a com object by using t-sql? : Sql server database administration

976

How to convert numeric expression data types using the cast() function?

1023

What is difference between count (*) and count 1?

883

How to add a new dsn with the odbc driver for sql server?

1023

What is @@rowcount in sql?

972

What is default constraint in ms sql server?

985

Describe triggers features and limitations?

949

How many databases Microsoft SQL server provides?

1047