SQL Dialects Reference/Write queries/Save results from select query as new table

From Wikibooks, the open-content textbooks collection

[edit] Save results from select query as new table

• PostgreSQL, MSSQL, Sybase T-SQL:

SELECT columns INTO new_table FROM table

• MySQL, PostgreSQL, OpenLink Virtuoso, Oracle, SQLite:

CREATE TABLE new_table [AS] SELECT columns FROM table

• Linter

CREATE TABLE new_table AS SELECT columns FROM table