RE: create table from results of a select, but add a sequence column.

Something like this:

select cusnum,lstnam,
ROW_NUMBER() OVER (
ORDER BY cusnum
) row_num
FROM
qiws/qcustcdt

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
------------------------------

message: 3
date: Tue, 28 Mar 2023 14:06:33 -0500
from: Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx>
subject: create table from results of a select, but add a sequence
column.

I am creating a result table (from a select statement).
then I add (insert into) records daily.

I wish to have a sequence column (use a sequence object?) added to this
table,
but can't find examples to pull this off. can someone help.