select top 1 sal from (select top n sal from tbl

how to find nth highest salary

Question Posted / kunal gupta

Answer Posted / kunal gupta

select top 1 sal from (select top n sal from tbl_master
group by sal order by sal desc)m order by sal

This answer is easiest and 100% tested

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the differences between web role and worker role?

122

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

967

What is explicit mode in sql server?

1069

What do you understand by replication in sql server? Mention the different types of replication in sql server.

956

Define self join in sql server joins?

961

What are the options which must be set to allow the usage of optimistic models?

966

Mention a few common trace flags used with sql server?

941

What command would you use to add a column to a table in sql server?

1318

Tell me something about security and sql azure?

114

What do you understand by recursive stored procedure?

943

How do I start and stop sql server?

1033

why would you call update statistics? : Sql server database administration

1098

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

987

Explain what is dbcc?

1017

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1406