January 25, 2017

Teradata SQL: Create table using Select statement

Execute following 2 SQLs:

1. create table tablex as
(
select
a,
b,
c
from table1
)
with no data;

2. insert into tablex
select
a,
b,
c
from table1;

No comments:

Post a Comment