Write queries to copy only few columns from table1 to table2
Write queries to create table2 which is same as table 1 (only create table2 ,not insert any data )
Write queries to create table2 which is same as table 1 (only create table2 ,not insert any data )
Rishikesh Kumar SinghPosted Jan 24, 2013, 8:43 AM
create table2 as select column1,column2 from table1;
Ans to Question 2:-
create table2 like table1;