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

How to update values in a table in oracle?

973

How to display row numbers with the records?

1039

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

1823

Â What are the oracle DML commands possible through an update strategy?

1015

How to calculate date and time differences in oracle?

1002

How to create an oracle database manually?

1031

How many categories of data types in oracle?

979

How to connect the oracle server as sysdba?

1028

What happens to the current transaction if a ddl statement is executed?

965

Which are the five query types available in oracle?

917

Can a formula column referred to columns in higher group ?

2471

How to convert a date to char in oracle? Give one example.

1014

How to Truncate Table in Oracle

1111

How to get a create statement for an existing table?

923

Which environment variables are absolutely critical in order to run the OUI?

2081