1 My Second Answer. Select Top 1 * From Tablename where salary in (sele

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

Question Posted / kumar

Answer Posted / kumar

1 My Second Answer.

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 ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Can We Use Data-grids For Our Report In Ssrs?

184

What is the purpose of a table?

961

What are the different types of cursor?

1097

Can we use trigger new in before insert?

927

What are relationships and mention different types of relationships in the dbms

965

What is function of master database?

114

How to Sync Two SQL Azure Databases?

121

Show Practically Sql Server Views are updatable?

1128

How to check if a table is being used in sql server?

971

Which are the two editions in which SQL Azure database available?

119

What is optimization and its types?

988

How do use Having,Group by,Group function in SQL?

1750

How do you create type- insensitive operator?

1048

When would you use a before or after trigger?

915

How to achieve Paging of records in SQL SERVER?

1104