Answer: Use below script:-
For Example:-
Select * INTO New_Tbl From Existing_Tbl;
It will copy all data along with all columns.
If we want to copy specific rows then give valid condition,so that where condition will satisfy.
Asked In: Many Interviews |
Alert Moderator