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 ;
we have to insert right?? So we have to write like:
ReplyDeleteinsert into Pending
select * from Accounts where amt_outstanding>10000: this??
But At first we have to create table.
Deletecan you provide the query to create the table?
Delete???
ReplyDeleteIs this ans complete
ReplyDeletePost a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )