Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ROWNUM - Questions

Re: ROWNUM - Questions

From: Paul Q <paulq_at_home.com>
Date: Mon, 18 Dec 2000 23:51:39 GMT
Message-ID: <fqx%5.151480$3u1.39650811@news3.rdc1.on.home.com>

TRY ROWID "Nicolas Bronke" <newsgroup_at_trinity.de> wrote in message 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 Mon Dec 18 2000 - 17:51:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US