select sal, rownum from (select sal from table order by sal desc)

How to Select second Maximum salary in a Table ?

Question Posted / sephali

Answer Posted / sephali

select sal, rownum
from (select sal from table
order by sal desc)
where rownum=2

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3020

What is partitioned table in Oracle?

1136

What is a sub query and what are the different types of subqueries?

1091

Explain self joins in oracle?

962

How to use subqueries with the in operator using oracle?

1057

how to do daily transactions with out sql* loader control file regesterd in apps?

1653

What is a synonym? What are its various types?

1068

Difference between hot backup vs. Cold backup?

958

How to define a data source name (dsn) in odbc manager?

990

How oracle handles dead locks?

1038

How to compare dates in oracle sql?

1069

How to start a new transaction in oracle?

1049

Explain what are the characteristics of data files?

1051

What to do if the startbd.bat failed to start the xe instance?

1040

What is the difference between PFILE and SPFILE in Oracle?

1012