-
Contributing Member
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.
-
Expert Member
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
-
Forum Rules