select top 1 sal from (select top 3 sal from emp order by sal desc )su

how to find nth highest salary

Question Posted / vijay

Answer Posted / vijay

select top 1 sal
from
(select top 3 sal
from emp
order by sal desc )sub
order by sal

Is This Answer Correct ?

12 Yes

24 No

Please Help Members By Posting Answers For Below Questions

What are trace flags?

1038

Introduction of rollup clause using sum and group by clause?

972

Which data type columns are the best candidates for full-text indexing?

975

What is the difference between set and select?

1102

How can i Relate Tables in SSIS

1088

Are null values the same as that of zero or a blank space?

1043

What is sql server database?

1021

What is data source document?

1046

How can I tell if sql server is 32 or 64 bit?

977

When columns are added to existing tables, what do they initially contain?

1041

What is change data capture (cdc) in sql server 2008?

1030

How you can get the list of largest tables in a database?

1024

What is a periodical index?

934

What do you understand by the analysis services in sql server?

949

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1068