SELECT

Write a query that returns data from tables and views.

Syntax

[ WITH name as (subquery) [, ...] ]
SELECT [ ALL | DISTINCT expression [ [ AS ] output_name ] [, ...] ]
    [ * | expression [ [ AS ] output_name ] [, ...] ]    
    [ FROM table_reference [, ...] ]
    [ WHERE condition ]
    [ GROUP BY { expression [, ...] ]|
      GROUPING SETS (expression [, ...]) |
      ROLLUP (expression [, ...]) |
      CUBE (expression [, ...]) } ]
    [ HAVING condition ]
    [ WINDOW window_name AS ( window_definition ) [, ...] ]
    [ { UNION | INTERSECT | { EXCEPT | MINUS } } [ ALL | DISTINCT ] select ]
    [ ORDER BY expression [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] [ COLLATE collation ] ]
    [ LIMIT { count | ALL } ]
    [ OFFSET start [ ROW | ROWS ] ]