Re: Sequence numbers / ordered queries

tlondon wrote
> > These numbers
> > should be applied to the sorted results

> Try using rownum in your query

<snip>
> rownum is assigned as the rows are being returned from the database.

... *before* any ordering is being done. So, bad luck, you can't use rownum.

Arjan. Received on Fri Apr 23 1999 - 09:52:42 CDT