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

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

Question Posted / divya

Answer Posted / divya

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

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is function of ROLLUP ?

1086

What do you understand by mirroring?

997

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

1075

Can we call stored procedure in trigger?

950

What are the disadvantages of merge replication?

1424

Tell me what is difference between view and materialized view?

938

Can you edit the .rdl code associated with a linked report?

163

Explain tablesample?

1000

What is row_number () and partition by in sql server?

1080

Does sql server use java?

1076

what is the difference between a primary key and a unique key? : Sql server database administration

1003

What is a view and what are its advantages?

1114

What is the correct order of the logical query processing phases?

936

What are subqueries in sql server? Explain its properties.

1019

What is side by side migration in sql server?

1107