Synopsis

CREATE TABLE table_name AS query

Description

Create a new table containing the result of a SELECT query. Use CREATE TABLE to create an empty table.

Examples

Create a new table orders_by_date that summarizes orders:

CREATE TABLE orders_by_date AS
SELECT orderdate, sum(totalprice) AS price
FROM orders
GROUP BY orderdate