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 sql server agent and what are the two modes of authentication in sql server?

1108

What is a trace frag? Where do we use it?

1150

Explain the stored procedure?

1094

What is store procedure?

1111

Define Unique Key?

1066

What are joins in sql and what are the different types of joins?

1059

What are the new scripting capabilities of ssms? : sql server management studio

1117

Why truncate is ddl command?

1112

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1074

What are the properties of the relational tables?

926

What does asynchronous call backs means?

1223

What is ms sql server index?

1149

What is resource db in sql server?

1056

Which language rdl files made of?

141

What is the new security features added in sql server 2014? : sql server security

1046