Re: ROWNUM - Questions

> 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;
>

This brings up the error
ORA-00907: I am using Oracle 8.05

Thanks

Nicolas Received on Mon Dec 18 2000 - 16:23:01 CST