Dear All,
[B][COLOR="DarkRed"]Select the Nth highest value from a table[/COLOR][/B]
[COLOR="SlateGray"][B]select level, max('col_name') from my_table
where level = '&n'
connect by prior ('col_name') > 'col_name')
group by level;[/B][/COLOR]
Have a pleasant time
:)