Re: ROWNUM - Questions

In our last gripping episode "Nicolas Bronke" <newsgroup_at_trinity.de> 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
>
>

I believe that unless you upgrade to 8i you'll not find a suitable solution to your problem. Essentially yours is a 'top-N' type of query and 8i does support 'top-N' constructs where earlier versions of 8 do not.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/