To do this, the SQL CREATE TABLE syntax is: CREATE TABLE new_table AS (SELECT * FROM old_table WHERE 1=2); For example: CREATE TABLE suppliers AS (SELECT * FROM companies WHERE 1=2);
One of the most essential T-SQL capabilities is the CREATE TABLE AS SELECT (CTAS) statement. CTAS is a concurrent operation that builds a new table from a SELECT statement's output. CTAS is the easiest and quickest way to create and insert data into a table with only one command.
The INSERT INTO SELECT statement transfers data from one table to another. The data types in the source and target tables must match for the INSERT INTO SELECT query to work. Existing records in the target table will not be modified.
If the database is shown under Recent, go to File > Open and choose it. If this is not the case, use one of the browse options to find the database.
Select the database you want to open in the Open dialogue box, then click Open.
Click Table in the Tables group on the Create tab.
Learner's Ratings
4.3
Overall Rating
69%
12%
8%
0%
11%
Reviews
R
ruhina qureshi
5
Awesome Classes ,Both tutors explains the concept very nice
Y
Yadav Aakash
5
very useful thank you learnvern
A
Ashish
5
The course is very good. I have stuck at a point that how you create multiple rows with a single insert in sales.customer table. I get only one customer data. this table is related to bikestore data.
N
nayazbasha sk
5
very useful thank you learnvern
M
Mahima Patel
5
very usefull......thanks
P
Priya Kushwaha
5
Very Good trainer
C
chanchal singh
5
you guys are doing nice job. thanks
U
Umesh Wankhede
5
Not too much interactive
M
Monesh Ram
5
Well Explained in Every Chapters..
G
GAJANAN DIGAMBAR MODE
5
very easy to understand SQL its was dream to learn SQL. Thanx for Learnvern
Share a personalized message with your friends.