Computer Science
Table Empl has same structure as that of table EMPL. Write a query statement to insert data from table NewEmpl into EMPL where salary and comm is more than Rs. 4000.
DDL & DML
1 Like
Answer
INSERT INTO Empl
SELECT *
FROM NewEmpl
WHERE SAL > 4000 AND COMM > 4000 ;
Answered By
3 Likes