SELECT

Description

Returns rows from tables, views, and user-defined functions. (Redshift SQL Language Reference SELECT statement)

Grammar Syntax

[ WITH with_subquery [, ...] ]
SELECT
[ TOP number | [ ALL | DISTINCT ]
* | expression [ AS output_name ] [, ...] ]
[ FROM table_reference [, ...] ]
[ WHERE condition ]
[ [ START WITH expression ] CONNECT BY expression ]
[ GROUP BY expression [, ...] ]
[ HAVING condition ]
[ QUALIFY condition ]
[ { UNION | ALL | INTERSECT | EXCEPT | MINUS } 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