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 define an anonymous procedure without variables?

1112

How to shutdown your 10g xe server?

1155

How to call a stored function in oracle?

1025

How to use null as conditions in oracle?

1092

How to define default values for formal parameters?

1054

Can we create database in oracle using command line ?

1093

What is oracle update statement with inner join ?

1068

What do you understand by a database object?

1074

How to download oracle database 10g xe?

1023

What is oracle instant client?

1030

Can we connect to ORACLE db using Windows Authentication?

1265

What is redo log?

1071

What do you know about normalization? Explain in detail?

956

How to open a cursor variable?

1045

What is a named program unit?

1092