Re: ROWNUM is out of order when ORDER BY clause used
From: Mike Rife <rife_at_aarlo.moffitt.usf.edu>
Date: 1995/04/28
Message-ID: <3nr4ri$ik5_at_mother.usf.edu>#1/1
Date: 1995/04/28
Message-ID: <3nr4ri$ik5_at_mother.usf.edu>#1/1
In article <3n13iv$12b6_at_rover.ucs.ualberta.ca>, jkoesvel_at_gpu.srv.ualberta.ca (Janice Koesveld) says:
>
>A user is trying to select records from a table in a specific order
>and would also like to number the rows retrieved using ROWNUM.
>Unfortunately, when he orders by a column, the ROWNUM is out of order.
>Is there some way to keep the sequence of ROWNUM and order by a table
>column?
No. ROWNUM is determined before the ORDER BY CLAUSE is applied to the resulting records. You can order by the ROWNUM by removing the ORDER BY CLAUSE or you can order by the column and possibly lose your ROWNUM order. Received on Fri Apr 28 1995 - 00:00:00 CEST