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

Table Creation and Data Manipulation Commands — Question 1

Back to all questions
1
Question

Question 1

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;