Question

Insert all those records of table account into table pending where amt_outstanding is more than 1000

Answer 1

select record from table

whose amt_outstanding >1000