This query will create a table with Name Employee2 with all data and same structure of Employee table, here only those column and column data will copy which I mention in Select command

SELECT name,Country, Mobile,Salary INTO Employee2 FROM Employee

This query will create a table with name Employee 3 by having the same structure of Employee table this query will not copy data

SELECT * INTO Employee3 FROM Employee WHERE 1=2

If we write this query as

SELECT * INTO Employee3 FROM Employee

then it will also copy all data.