select max(sal) from emp where sal not in (select top2 sal from emp order b

How to Select second Maximum salary in a Table ?

Question Posted / kuldeep singh

Answer Posted / kuldeep singh

select max(sal) from emp where sal not in (select top2 sal from emp order by sal desc)

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How can you merge two tables in oracle?

1008

Define oracle database

1050

Explain the features of oracle?

1057

Explain the difference between a procedure and a function?

1182

What are the ansi data types supported in oracle?

953

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

1071

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2344

How to drop a tablespace?

1055

How to get a list of all background sessions in the database?

994

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2271

Explain integrity constraint?

1164

What happens to the indexes if a table is recovered?

993

What is a snapshot in oracle database?

1030

ABOUT IDENTITY?

2064

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1054