SELECT MAX( salary) FROM salary where salary not in( SELECT DISTINCT TOP 3

how to find nth highest salary

Question Posted / shiva

Answer Posted / shiva

SELECT MAX( salary) FROM salary where salary not in(
SELECT DISTINCT TOP 3 salary FROM salary order by salary desc)

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to apply cascading referential integrity in place of triggers?

1037

What is nested transaction?

1106

Is it possible for a stored procedure to call itself or recursive stored procedure?

952

What is collation sensitivity?

1072

What does nvl stand for?

946

How to drop existing views from a database in ms sql server?

1107

What is mssql?

989

What command do we use to rename a database?

1082

What is difference between getdate and sysdatetime in sql server 2008?

1055

Why do we need different type of parameter?

1063

What is query cost in sql server?

999

What is inner join in sql server joins?

1043

What are different replication agents and what's their purpose? : sql server replication

1025

What are the disadvantages of indexes?

1091

Explain about merge replications?

1031