In teradata, can you insert a cte into a table?

Asked Sep 25 '21 at 13:11

Active Oct 06 '21 at 09:33

Viewed 737 times

I've looked at the other postings but I haven't seen a resolution for this.

CREATE TABLE newtable AS (SELECT * FROM yourtable) with no data ;

Then

with cte as (
select top 10* from yourtable
)

insert into newtable

select * from cte

select * from newtable

I get an error saying it expects a select and not an insert.
How would I accomplish inserting the cte into a table?

edited Oct 06 '21 at 09:33

Yun

asked Sep 25 '21 at 13:11

ctk

Yes, just make the WITH part of the SELECT not the INSERT – Fred Sep 25 '21 at 15:48
Not exactly sure what you mean. Could you just post the code? – ctk Sep 25 '21 at 19:17
1

`insert into newtable with cte as ( select top 10* from yourtable) select * from cte` – dnoeth Sep 25 '21 at 21:57

0 Answers0