Product Documentation

Appearance

All platforms

SELECT ​

Write a query that returns data from tables and views.

Syntax ​

[ SETTING (hint [; ...])]
[ 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 ] ]