Re: Proper syntax for select *, rownum

> select rownum, * from mytable;
>
> What's the proper syntax??

select rownum, mytable.* from mytable
or
select rownum, myalias.* from mytable myalias

Stephan Received on Wed Aug 06 2003 - 08:16:48 CDT