[sql]select max(value) from table where value not in (select max(value) from the table);[/sql]

or


[sql]select level,max(value) from table where level=2 connect proir by value>value group by level;[/sql]


vivek