Select top 1 salary from table where salary in(select top 2 salary from ta

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

Question Posted / sandeep rana

Answer Posted / sandeep rana

Select top 1 salary from table where salary in(select top 2
salary from table order by salary desc)order by salary

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the purpose of floor function?

978

how you can get the list of largest tables in a database? : Sql server administration

989

What is the maximum size per database for sql server express?

975

Explain trigger classes i.e. Instead of and after trigger?

826

What is the security model used in sql server 2005?

936

We need to perform what steps in the following order to work with a cursor?

1170

Can we use having clause without group by?

931

How to name query output columns in ms sql server?

918

What is a domain constraint give an example?

1005

How to create a testing table with test data in ms sql server?

1016

What is abstracting periodical?

897

What is efficiency data?

906

Explain the collation?

1047

How to filter records of table in SQL SERVER?

1027

What is mean by dml?

946