Re: Proper syntax for select *, rownum

Thanks Stephan

"Stephan Bressler" <agadir_at_web.de> wrote in message news:3F30FFC0.1060409_at_web.de...
>
>
> > 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 - 09:46:35 CDT