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