select max(sal) from Table where sal not in(select max(sal) from Table);

How to Select second Maximum salary in a Table ?

Question Posted / guest

Answer Posted / guest

select max(sal) from Table
where sal not in(select max(sal) from Table);

Is This Answer Correct ?

20 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is a user account in oracle?

1166

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4414

What is oracle and what are its different editions?

1118

What is a named program unit?

1136

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

1106

How to write an inner join with the where clause in oracle?

1089

Can you create a synonym without having a table?

1090

Explain the dml?

1042

Point out the difference between user tables and data dictionary?

1032

what is dynamic SGA and static SGA

4482

When do I need to use a semicolon vs a slash in oracle sql?

1141

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

2338

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2173

What is not equal to in oracle?

1047

what is the dual table in oracle?

1037