Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

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

Geeks Talk > Databases > SQL Is Order by on Rownum Possible

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   07-29-2006

Bessie Contributing Member   Join Date: Jul 2006 Posts: 52 Thanks: 0 Thanked 1 Time in 1 Post

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

#2 (permalink)   08-17-2006

jamesravid Expert Member   Join Date: Jun 2006 Location: India Posts: 411 Thanks: 15 Thanked 32 Times in 24 Posts

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.

Geeks Talk > Databases > SQL

« Triggers Types | Query with a command in DBMS »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

All times are GMT -4. The time now is 06:51 PM.