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


Answer =

Query if you have already created table Pending :-

Insert into Pending
Select * from Accounts where amt_outstanding > 10000 ;


Query if you have not created Pending table in your database :-


Create table Pending Select * from Accounts where amt_outstanding > 10000 ;

Post a Comment

You can help us by Clicking on ads. ^_^
Please do not send spam comment : )

Previous Post Next Post