select max(salary) from table where salary<(select max (salary) from ta

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

Question Posted / kumar_kisna

Answer Posted / kumar_kisna

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

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to see the event list of an existing trigger using sys.trigger_events?

1026

What is collation?

1099

How to use order by with union operators in ms sql server?

969

What are points to remember while using the fillfactor argument?

909

Does table partitioning improve performance?

905

What is co-related sub query?

978

What is sql server profiler trace data file?

1052

What is 'write-ahead log' in sql server 2000 ?

991

Which language is supported by sql server?

956

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

951

Why olap is used?

921

What is exporting utility?

954

What does it mean to invest in the index?

906

What is indexed view? How to create it?

932

What is a fan-out query in SQL Azure?

121