get the value before max( )

[rk68]

How do I get the value before the max value.
If I say select max(srno) from table, I get certain value.
Now I need to know the value before the max(srno).
How can I do this using Oracle Pl/Sql ? Is there any
function available ?

TIA

Raj

 

[TISIBS]

In SQL (scott/tiger);

SELECT sal
FROM (SELECT sal
FROM (SELECT sal FROM emp ORDER BY 1 DESC)
WHERE rownum < 3
ORDER BY 1)
WHERE rownum < 2

in PL/SQL you can use SELECT INTO ...

Timo

 

[SimonSellick]

or

select max(col)
from tbl
where col < (
  select max(col)
  from tbl
)