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.
Printable View
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.
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.