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 difference between inner join and join?

1096

How to provide login information for a new odbc dsn?

1099

How to list all field names in the result set using mssql_field_name()?

952

Does sql server 2000 full-text search support clustering?

915

What are the types of table?

1031

Write a sql query to sort on different column name according to the parameters passed in the function?

964

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1269

Why transaction is important?

1023

What are the advantages of log shipping?

1039

What does this statement do @@rowcount?

1016

How are the exceptions handled in sql server programming?

1119

How to create a new schema in a database?

1211

What is Command line parameters in PLSQL.?

1195

Explain the xml support sql server extends?

1083

How to override dml statements with triggers?

1278