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

What is difference statement and preparedstatement?

987

How do you troubleshoot errors in a SQL Server Agent Job?

1066

What is tempdb database? : SQL Server Architecture

1201

How do I open port 1433?

936

How to use subqueries with the exists operators in ms sql server?

1122

What new data source types were added in ssrs 2014?

160

Can you type more than one query in the query editor screen at the same time?

1011

What is dirty read?

1086

what are triggers? : Sql server database administration

910

How to compare the top two records using sql?

1348

how can a database be repaired? : Sql server administration

980

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

881

what is database replication? : Sql server database administration

1073

Do you know how to implement service broker?

932

Tell me about pre-defined functions of sql?

1112