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

Explain the different normalization forms?

598

What is a dynamic performance view in oracle?

609

How to pass a cursor variable to a procedure?

564

Can we store pictures in the database and if so, how it can be done?

596

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1635

What are the components of logical database structure in oracle database?

586

How do I know if oracle client is installed on windows?

501

How to count groups returned with the group by clause in oracle?

580

How many types of database triggers exist?

582

Why does oracle 9i treat an empty string as null?

540

How does one get the view definition of fixed views/tables?

608

How to empty your oracle recycle bin?

575

What is background process in Oracle?

630

What are the ways tablespaces can be managed and how do they differ?

1620

What is ASM (Automatic Storage Management) in Oracle?

717