Which Of The Following Sql Statement Is Used To Create A Table #327
Which of the following SQL statement is used to create a table by copying only the selected columns from another table?
This multiple choice question (MCQ) is related to the book/course
gs gs115 Structured Query Language.
It can also be found in
gs gs115 SQL Database - SQL Create Table - Quiz No.1.
Which of the following SQL statement is used to create a table by copying only the selected columns from another table?
CREATE TABLE new_tablename AS ( SELECT * from old_tablename where condition);CREATE TABLE new_tablename AS ( SELECT Column1, Column2...Columnn from old_tablename);CREATE TABLE new_tablename AS ( SELECT Column1, Column2...ColumnN from old_tablename1, old_tablename2...old_tablenamen);CREATE TABLE table_name (column1 datatype constraint column2 datatype constraint column3 datatype constraint ... columnn datatype constraint);
