SQL Dialects Reference/Write queries/Insert results from select query into existing table

From Wikibooks, the open-content textbooks collection

[edit] Insert results from select query into existing table

• DB2, Firebird, MSSQL, MySQL, Oracle, PostgreSQL, SQLite, OpenLink Virtuoso, Linter:

INSERT INTO existing_table SELECT columns FROM table