Re: Counter

amerar_at_iwc.net wrote:
> Hi All,
>
> I'm looking around right now to see if this is possible, but I thought
> I'd ask here too.
>
> Can you have a record counter in an insert statement? Something like
> this:
>
> INSERT INTO table_a (
> SELECT flda, fldb, fldc, i++, fldd FROM tableb);
>
> Basically there is one column that is a record counter. And since
> this is not a loop, I'm not sure how it is done. Maybe a sub-select
> with a count(*)??
>
> Thanks a bunch!

rownum

-- 

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up