Creating a Table from another Table?

Creating a Table from another Table?

Select  * <columnlist> into <new table> from <oldtable>

 [where <condition>]

It copy the content of old table to new table

In this examples, copy all the content  of emp  table into new emp1 table