Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Is Order by on Rownum Possible
This is a discussion on Is Order by on Rownum Possible within the SQL forums, part of the Databases category; 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 ...
|
|||||||
07-29-2006
|
|||
|
|||
|
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.
|
| Sponsored Links |
|
08-17-2006
|
|||
|
|||
|
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.
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT -4. The time now is 09:29 PM.
