Re: ROWNUM - Questions

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: Mon, 18 Dec 2000 16:15:03 -0500
Message-ID: <3A3E7E57.6BE1F8A7@Unforgetable.com>

Nicolas Bronke wrote:

> ROWNUM is nice, but for my appl. the pity is that ROWNUM is independet to a
> ORDER by. That mean
>
> select rownum,columnname from tablename
> and
> select rownum,columnname from tablename order by columnname
>
> brings not the rownumbering I am looking for.
>
> I need a rownumbering which is independent from the ordering.
>
> Any suggestions?
>
> Thanks
>
> Nicolas

This may not be the total answer you are looking for,but try:

select rownum,columname
from (select columname from tablename order by 1) order by 1; Received on Mon Dec 18 2000 - 15:15:03 CST