select top 1 * from (select top 2 * from emp order by sal desc ) a orde

can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com

Question Posted / darshan shah

Answer Posted / darshan shah

select top 1 * from (select top 2 * from emp order by sal
desc ) a order by sal asc

Plz try this.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are sql server functions?

962

How do you identify a foreign key?

1009

What are the types of stored procedures in an sql server?

969

What types of replication are supported in sql server?

1048

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1050

What are different types of statements that are supported by sql?

1021

Difference between report and query parameter. Why do we need different type of parameter?

932

How to find the service pack installed? : sql server database administration

1010

What is mapping schema?

1010

Is it true, that there is no difference between a rule and a check constraint?

1021

What are the two authentication modes in sql server?

1097

what are the different types of replication you can set up in sql server? : Sql server database administration

1009

How to apply cascading referential integrity in place of triggers?

1019

What is the federation in sql azure?

Define Unique Key?

985