SELECT INTO
SQL - Language Statements
SELECT INTO
Create a new table from an existing table or view
2000-12-11
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
* | expression [ AS output_name ] [, ...]
INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table
[ FROM from_item [, ...] ]
[ WHERE condition ]
[ GROUP BY expression [, ...] ]
[ HAVING condition [, ...] ]
[ { UNION | INTERSECT | EXCEPT [ ALL ] } select ]
[ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]
[ FOR UPDATE [ OF tablename [, ...] ] ]
[ LIMIT { count | ALL } [ { OFFSET | , } start ]]
where from_item can be:
[ ONLY ] table_name [ * ]
[ [ AS ] alias [ ( column_alias_list ) ] ]
|
( select )
[ AS ] alias [ ( column_alias_list ) ]
|
from_item [ NATURAL ] join_type from_item
[ ON join_condition | USING ( join_column_list ) ]
1998-09-22
Inputs
All input fields are described in detail for
.
1998-09-22
Outputs
All output fields are described in detail for
.
1998-09-22
Description
SELECT INTO creates a new table from the results
of a query. Typically, this
query draws data from an existing table, but any SQL query is allowed.
is functionally equivalent to the SELECT INTO command.