Re: ROWNUM - Questions

Try select rownum,columnname from tablename,dual where columnname=dummy(+)

"Nicolas Bronke" <newsgroup_at_trinity.de> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:91ltqn$j23$05$1_at_news.t-online.com...
> 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
>
>
Received on Tue Dec 19 2000 - 04:19:46 CST