copy table in sql

1-- Use SELECT ... INTO:
2SELECT * INTO my_table_1 FROM my_table;
3-- Structure only:
4SELECT * INTO my_table_1 FROM my_table WHERE 1 <> 1;

1CREATE TABLE employees_copy
2 AS 
3 SELECT first_name, last_name, email FROM employees WHERE 1=0;

1#The SELECT INTO statement selects data from one table and inserts it into a different table. 
2#The SELECT INTO statement is most often used to create backup copies of tables. 
3syntax->SELECT *
4INTO new_table_name [IN externaldatabase]
5FROM old_tablename 
6///example///
7SELECT *
8INTO Persons_Backup
9FROM Persons