Tech Diary
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
‹
›
Home
View web version
No comments:
Post a Comment