KnowledgeBoat Logo

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


Related Questions