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 is a synonym for manipulation?

934

What is subquery explain with example?

1009

How to select all columns of all rows from a table with a select statement in ms sql server?

1046

Can we perform backup restore operation on tempdb?

955

Is sql server implemented as a service or an application? : Sql server database administration

897

How many types of triggers are there?

1004

How to find out the list schema name and table name for the database?

894

What are commonly used odbc functions in php?

974

Explain what are partitioned views and distributed partitioned views?

893

State the difference between union and union all?

890

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

962

What are the different types of cursor?

1042

What is sql sandbox in sql server?

1149

What do you mean by normalisation?

965

How to name query output columns in ms sql server?

918