Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 15 of 79

Table Creation and Data Manipulation Commands — Question 9

Back to all questions
9
Question

Question 9

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.

Answer 
INSERT INTO Empl 
SELECT *
FROM NewEmpl
WHERE SAL > 4000 AND COMM > 4000 ;