Select Top 1 * From Tablename 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 / rajendra

Answer Posted / rajendra

Select Top 1 * From Tablename where salary in
(select top 2 salary from tablename order by salary desc)
order by salary asc

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we use where clause with group by?

883

How many columns can exist together per table?

1140

What gets stored inside msdb database?

1233

What is the difference between ‘having’ clause and a ‘where’ clause?

1028

How would you go about developing a ssrs report?

166

List out a number of the wants to setup a SQL Server failover cluster?

1047

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

962

Explain about SQLOS?

986

How would we use distinct statement? What is its use?

1053

Explain throw statement in sql server 2008?

971

Does the order of columns in update statements matter?

906

How to view existing indexes on an given table using sys.indexes?

1070

What is model database? : SQL Server Architecture

1110

How do you rebuild an identity column?

936

What are the differences between local and global temporary tables?

1059