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 sql server profiler?

1062

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1099

How do I start sql server 2017?

986

Define self join?

1078

What are the different types of triggers in SQL SERVER?

1189

What are window functions in sql server?

1068

How do I setup a local sql server database?

1070

Can we call stored procedure in view in sql server?

940

Explain sql server authentication modes?

1188

What is the minimum recommended amount of ram for sql server 2012 enterprise?

980

What is the difference between Stored Procedures and triggers?

1133

What is update_statistics command?

1121

What is equi join with example?

1230

What are the differences between local and global temporary tables?

1131

Why should one not prefix user stored procedures with ‘sp_’?

1099