How To Write Insert Into Select Query In SQL

Yasin Panwala Nov 21, 2019 0 673

Yasin Panwala

• 149
• 331.3K
• 3.86K
• 1

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web ...

In this article, we will learn how to write a SQL insert into select query.

To copy data from one table and insert it into another table in SQL, the INSERT INTO SELECT statement is used.

Data types in source and target table should match.
Existing records in the target table are unaffected.