Thread: Tips of the Day

Dear All,

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;

Have a pleasant time

When you are posting somthing like this you also need to post few explanations like the use if LEVEL,CONNECT BY and PRIOR key words. That willl be easier and better for new programmers.