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 ;

5 Comments

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

  1. we have to insert right?? So we have to write like:

    insert into Pending
    select * from Accounts where amt_outstanding>10000: this??

    ReplyDelete
    Replies
    1. But At first we have to create table.

      Delete
    2. can you provide the query to create the table?

      Delete
  2. Is this ans complete

    ReplyDelete

Post a Comment

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

Previous Post Next Post