Results 1 to 2 of 2

Thread: Is Order by on Rownum Possible

  1. #1
    Contributing Member
    Join Date
    Jul 2006
    Answers
    52

    Is Order by on Rownum Possible

    Can we use order_by on a rownum. Will this give me error? If not what would be the result like. Anyone who has tried this give your inputs here in this discussion.


  2. #2
    Expert Member
    Join Date
    Jun 2006
    Answers
    410

    Re: Is Order by on Rownum Possible

    You can order the result set by ROWNUM. But it will make no sense if you order by rownum in ascending order (i hope you understand this statement).
    order by rownum in descending displays records in reverse order.

    --James.


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