Bright Tutorials

CBSE Class 12 Informatics Practices Question 14 of 25

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;

Get the Bright Tutorials app Stuck on a question? Ask Bright Buddy — your AI tutor — for step-by-step help in the app. Get it →