SCRIPTS :

Run the following script :


Select the Nth highest value from a table

select level, max('col_name') from my_table
where level = '&n'
connect by prior ('col_name') > 'col_name')
group by level;