Create Table from existing table
Select * INTO tbem1 from tbemp where 1=2
Because none of the record could satisfy this condition i.e. 1=2. So no data would be copied into newly created table.
Select * INTO tbemp2 from tbemp
Select * INTO tbemp3 from tbemp where depcod=102
Here depcod denotes to department code.