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

How many columns can exist together per table?

1097

What is the cpu pressure?

988

Mention the 3 ways to get a count of the number of records in a table.

917

How do I find the default sql server instance?

902

Do you know data definition language, data control language and data manipulation language?

979

what is a self join? Explain it with an example? : Sql server database administration

880

What is model database in sql server?

1001

What is repeatable read?

933

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

933

Which table keeps the locking information?

879

Can sql server 2016 run on windows 7?

857

Is mysql better than sql server?

1000

Will count(column) include columns with null values in its count?

1032

What are Row versions of DataRow?

972

What is the datatype of rowid?

875