Neoview SQL Reference Manual (R2.3)

from (
insert into identity_table values
(DEFAULT,100,100),
(DEFAULT,200,200)
)X;
A B C
--------------- ------ ------
216944652091640 100 100
216944652091641 200 200
• INSERT...SELECT statements are supported with embedded INSERT statements:
insert into another_table values (300,300,300),
(400,400,400),
(500,500,500);
select P.a, P.b, P.c
from (
insert into identity_table
select * from another_table where y < 500
) as P where P.a = 300;
A B C
--------------- ------ -------
300 300 300
SELECT Statement 165