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 is the difference between a check constraint and a rule?

1253

What the different components in replication and what is their use?

953

Which table keeps the locking information?

923

Why use triggers?

1014

Does windows server 2016 come with sql server?

938

Explain system views?

1089

What are the advantages of partitioning?

1130

where can you add custom error messages to sql server? : Sql server administration

1120

When would you use sql joins?

962

Define left outer join in sql server joins?

965

Explain the Ways to improve the performance of a sql azure database?

Do you know how to send email from database?

1005

Tell me what is de-normalization and what are some of the examples of it?

1050

What is openrowset sql server?

1131

What is onf in normalization form?

1056