8. SQL Statements : SELECT (interactive) : Select (interactive) Syntax
 
Share this page                  
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]