Select (interactive) Syntax
The SELECT (interactive) statement has the following format:
[WITH common_table_expression]
SELECT [FIRST rowCount] [ALL | DISTINCT] * | expression [AS result_column]
{, expression [[AS] result_column]}
[FROM from_source {, from_source}
[WHERE search_condition]
[GROUP BY [ALL | DISTINCT] grouping element {,grouping element}]
[HAVING search_condition]
{UNION [ALL]
(select)}
[ORDER BY ordering-expression [ASC | DESC]
{, ordering-expression [ASC | DESC]}];
[OFFSET n]
[FETCH FIRST|NEXT n ROWS|ROW ONLY]
[WITH options]