select max(salary)from tablename where salary <(select max(salary)from

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

Question Posted / elumalai.k

Answer Posted / elumalai.k

select max(salary)from tablename where salary <(select
max(salary)from tablename)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to find the source of a table in sql server?

925

How many levels of sp nesting is possible?

999

What is ems sql management studio? : sql server management studio

1039

What is the difference between migration and upgradation in sql server?

1041

What are the different editions available in sql server 2000?

995

Explain view in sql server?

1009

Explain use of expression builder.

953

Explain what are the database objects? : SQL Server Architecture

1006

How to count duplicated values in a column in ms sql server?

999

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1157

How do database indexes work?

956

What are the recovery models for a database?

1058

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

116

What is resultset concur_updatable?

972

What do you mean by collation recursive stored procedure?

1013