Results 1 to 2 of 2

Thread: Tips of the Day

  1. #1
    Contributing Member
    Join Date
    Nov 2007
    Answers
    53

    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



  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    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
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact