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

Can group functions be mixed with non-group selection fields?

1071

What are the different pseudo commands? Explain in general?

1122

In the oracle version 9.3.0.5.0, what does each number shows?

1343

What are the different types of failures that occur in Oracle database?

1116

How can I see all tables in oracle?

1060

What is an oracle user account?

1038

What are oracle functions?

1087

How to use "startup" command to start default instance?

1099

Is it possible to split the print reviewer into more than one region ?

2338

How to define an oracle cursor variable?

1090

How to compare dates in oracle sql?

1159

What is oracle host variable?

1129

What is a user account in oracle?

1166

Can we call procedure inside function in oracle?

1147

Explain the use of constraints option in exp command.

1079