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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment