Re: ROWNUM is out of order when ORDER BY clause used
From: Madhavi Lokam <gmadhavi_at_pms991.pms.ford.com>
Date: 1995/04/25
Message-ID: <3njfhs$ons_at_eccdb1.pms.ford.com>#1/1
Date: 1995/04/25
Message-ID: <3njfhs$ons_at_eccdb1.pms.ford.com>#1/1
In article <3n13iv$12b6_at_rover.ucs.ualberta.ca>, jkoesvel_at_gpu.srv.ualberta.ca (Janice Koesveld) writes:
|> 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?
ROWNUM is first assigned when ORACLE retrieves the rows and then ORDER BY on the specified COLUMN is applied. So they will be out of ORDER.
Madhavi Lokam Received on Tue Apr 25 1995 - 00:00:00 CEST