Insert Data from Another Table

Syntax:- insert into tablename select query
       Ex:-     1   insert into employ select * from vision;
                   2   Insert into employ2 select eno,sal from employ;
                   3   Insert into employ select * from vision where sal>3000;