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;

 

For
Online Classes

Contact Us: +919885348743