SELECT MIN(SALARY) FROM tablealies.Table_Name WHERE SALARY IN (SELECT DIS

how to find nth highest salary

Question Posted / dilip

Answer Posted / dilip

SELECT MIN(SALARY) FROM tablealies.Table_Name WHERE SALARY
IN (SELECT DISTINCT TOP N MAX(SALARY) FROM
tablealies.Table_Name ORDER BY SALARY DESC)

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is 1nf 2nf and 3nf?

893

What is the fillfactor concept in indexes?

990

According to you what goes into making the best database administrator? : sql server database administration

981

What do we need queues in sql service broker?

1073

Explain system functions or built-in functions? What are different types of system functions?

985

What are the rendering extensions of ssrs?

157

Define right outer join?

984

What is the difference between char, varchar and nvarchar?

1027

How to populate a table in sql server?

966

Where the sql logs gets stored?

992

What is the ‘fillfactor’?

973

How can you append an identity column to a temporary table?

957

What is the purpose of forms?

961

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1034

Explain linked server in sql?

1229