All Forums Database
Gowtham 16 posts Joined 12/12
20 Feb 2013
How to insert recursive query answerset to another table

Hi,
 
For a looping concept, i had done a query in recursive but i dont know how to load the result to another table,
I need your help to load the answerset to another table.
 
Thanks

dnoeth 4628 posts Joined 11/04
21 Feb 2013
insert into target
with recursive cte as
(select ...)
select * from cte

Dieter
 

Dieter

Gowtham 16 posts Joined 12/12
22 Feb 2013

Thanks Dieter.

04 Nov 2015

WHAT IS THE TARGET TABLE HERE..IF WE WANT TO INSERT SPECIFIC COLUMN HOW DO WE DO IT?

Qaisar Kiani 337 posts Joined 11/05
25 Jun 2016

All the columns selected at the end of recursive query are inserted in the table. If you want to insert some specific columns then select only those ones.

You must sign in to leave a comment.