Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 22 of 79

MySQL SQL Revision Tour — Question 15

Back to all questions
15
Question

Question 12

Insert all those records of table Accounts into table Pending where amt_outstanding is more than 10000.

Answer 
INSERT INTO Pending
SELECT * FROM Accounts
WHERE amt_outstanding > 10000;