Re: Counter
From: Steve Howard <stevedhoward_at_gmail.com>
Date: Wed, 6 Feb 2008 07:40:26 -0800 (PST)
Message-ID: <9a3a0ad9-917d-43a9-a36b-b67498b1ddea@v4g2000hsf.googlegroups.com>
Date: Wed, 6 Feb 2008 07:40:26 -0800 (PST)
Message-ID: <9a3a0ad9-917d-43a9-a36b-b67498b1ddea@v4g2000hsf.googlegroups.com>
On Feb 6, 10:04 am, "ame..._at_iwc.net" <ame..._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!
Hi,
Why not just use rownum?
Regards,
Steve Received on Wed Feb 06 2008 - 09:40:26 CST