{"id":130344,"date":"2022-04-13T18:00:01","date_gmt":"2022-04-13T22:00:01","guid":{"rendered":"https:\/\/brainstation.io\/?post_type=codex-reference&p=130344"},"modified":"2025-02-04T14:40:29","modified_gmt":"2025-02-04T19:40:29","slug":"insert-into-select","status":"publish","type":"codex-reference","link":"https:\/\/brainstation.io\/learn\/sql\/insert-into-select","title":{"rendered":"Insert Into Select"},"content":{"rendered":"\n
<\/path><\/path><\/path><\/g><\/path><\/path><\/path><\/g><\/svg>

SQL tutorial<\/p><\/div>

SQL Insert Into Select<\/h1>

Learn more about SQL, a standard language for interacting with databases and storing, manipulating, and retrieving data from databases.

Go hands-on with SQL in our free interactive SQL tutorial.<\/a><\/p><\/div>

<\/div><\/div><\/div><\/header>\n\n\n\n
\n
\n

The INSERT<\/code> statement in SQL can be combined with a query (SELECT<\/code> statement) in order to write out the results into a new table. This can be useful for a Data Analyst to save the results of an ad hoc query into an intermediary or working table, or may also be commonly seen in automated transactional queries writing or appending data to tables at a regular cadence (e.g. <\/em>daily updates of customer information in a retail database).<\/p>\n\n\n\n

In this case, the INSERT<\/code> statement takes the same form as before, only instead of using VALUES<\/code> and providing the data in the statement itself, we use SELECT<\/code> and the result is what is inserted into the destination table. The statement takes the form:<\/p>\n\n\n\n

Code Example<\/span>