SELECT INTO

Description

Returns rows from tables, views, and user-defined functions and inserts them into a new table. (Redshift SQL Language Reference SELECT statement)

Grammar Syntax

[ WITH with_subquery [, ...] ]
SELECT
[ TOP number ] [ ALL | DISTINCT ]
* | expression [ AS output_name ] [, ...]
INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table
[ FROM table_reference [, ...] ]
[ WHERE condition ]
[ GROUP BY expression [, ...] ]
[ HAVING condition [, ...] ]
[ { UNION | INTERSECT | { EXCEPT | MINUS } } [ ALL ] query ]
[ ORDER BY expression
[ ASC | DESC ]
[ LIMIT { number | ALL } ]
[ OFFSET start ]

For more information please refer to each of the following links:

1. WITH clause
2. SELECT list
3. FROM clause
4. WHERE clause
5. CONNECT BY clause
6. GROUP BY clause
7. HAVING clause
8. QUALIFY clause
9. UNION, INTERSECT, and EXCEPT
10. ORDER BY clause
11. LIMIT and OFFSET clauses
12. Local Variables and Parameters