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 is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1076

What is the largest component inside a field?

1187

What are unicode character string data types in ms sql server?

1344

What are the commands used in DCL?

1082

What is ssl in sql server?

1132

What is clustered primary key?

1082

What is enhanced database mirroring in sql server 2008?

1033

How to create new table with "create table" statements?

1192

What are the different kinds of ssrs reports?

221

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1066

what are user defined datatypes? : Sql server database administration

1015

What is the difference between inner join and equi join?

1041

Define right outer join?

1016

How to maintain a fill factor in existing indexes?

1052

Can we use custom code in ssrs?

1165