SELECT
SELECT statements can be used to retrieve data from one or more tables. Timestream's query language supports the following syntax for SELECT statements:
[ WITH with_query [, ...] ]
SELECT [ ALL | DISTINCT ] select_expr [, ...]
[ function (expression) OVER (
[ PARTITION BY partition_expr_list ]
[ ORDER BY order_list ]
[ frame_clause ] )
[ FROM from_item [, ...] ]
[ WHERE condition ]
[ GROUP BY [ ALL | DISTINCT ] grouping_element [, ...] ]
[ HAVING condition]
[ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] select ]
[ ORDER BY order_list ]
[ LIMIT [ count | ALL ] ]where
-
function (expression)is one of the supported window functions. -
partition_expr_listis:expression | column_name [, expr_list ] -
order_listis:expression | column_name [ ASC | DESC ] [ NULLS FIRST | NULLS LAST ] [, order_list ] -
frame_clauseis:ROWS | RANGE { UNBOUNDED PRECEDING | expression PRECEDING | CURRENT ROW } | {BETWEEN { UNBOUNDED PRECEDING | expression { PRECEDING | FOLLOWING } | CURRENT ROW} AND { UNBOUNDED FOLLOWING | expression { PRECEDING | FOLLOWING } | CURRENT ROW }} -
from_itemis one of:table_name [ [ AS ] alias [ ( column_alias [, ...] ) ] ] from_item join_type from_item [ ON join_condition | USING ( join_column [, ...] ) ] -
join_typeis one of:[ INNER ] JOIN LEFT [ OUTER ] JOIN RIGHT [ OUTER ] JOIN FULL [ OUTER ] JOIN -
grouping_elementis one of:() expression
