Syntax
The SELECT (interactive) statement has the following format:
SELECT [FIRST rowCount] [ALL | DISTINCT]
* | result_expression{, result_expression}
[FROM from_source {, from_source}
[WHERE search_condition]
[GROUP BY column{, column}]
[HAVING search_condition]
{UNION [ALL]
(select)
[ORDER BY result_column [ASC | DESC]
{, result_column [ASC | DESC]}];
where result_expression is one of the following:
• [schema.]tablename.*
Selects all columns
• [[schema.]tablename.]columnname [[AS] result_column]
Selects one column
• expression [AS] result_column