select max(sal) from table_name where sal<(select max(sal) from table

How to Select second Maximum salary in a Table ?

Question Posted / tanuj tewari

Answer Posted / tanuj tewari

select max(sal) from table_name where sal<(select max(sal)
from table_name);

Is This Answer Correct ?

15 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is sharded cluster?

924

What is transport network substrate (tns) in oracle?

991

How to select an oracle system id (sid)?

1017

What is BBED in Oracle?

1088

What is a initialization parameter file in oracle?

986

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2431

How will you write a query to get a 5th rank student from a table student_report?

1812

What privilege is needed for a user to connect to oracle server?

938

What is an Oracle index?

1601

How to loop through a cursor variable?

1010

What exactly do quotation marks around the table name do?

915

What is the difference between sharding and replication?

954

How to count duplicated values in a column in oracle?

981

What types of joins are used in writing subqueries?

936

what is Single Byte Overhead...?

2497