How to insert more than one record using insert?

Answer Posted / nahid gorji

using insert into table1 (column-list or *) 479 select
column-list or * from another table

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of dclgen in db2?

586


What is the role of union all and union

648


What are the bind parameters ibm db2?

622


What are bind parameters in db2?

611


What does db2 mean?

579






What is the purpose of using commit?

616


What are concurrency issues?

626


How to run db2 command in windows?

643


What is dbrm?

636


How can you classify the locks in db2?

628


What is universal database?

616


How would you find out the total number of rows in a db2 table?

574


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1574


What are the benefits of using the db2 database?

658


How can you do the explain of a dynamic sql statement?

635