-
Contributing Member
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
-
Re: Tips of the Day
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules