|
query_specification
|
|
|---|---|
|
query_specification
|
::= S ELECT [DISTINCT | ALL] select_list table_expression
|
|
select_list
|
::= * | select_sublist
[ {, select_sublist } ... ] |
|
select_sublist
|
::= derived_column |
[ table_name | table_identifier ].* |
|
derived_column
|
::= expression [ [AS] column_alias ] ]
|
|
table_expression
|
::= FROM table reference list
[WHERE search_condition ]
[GROUP BY column_name_list
[[UNION | INTERSECT | EXCEPT] [ALL]
[CORRESPONDING [BY ( column_name_list ) ]
query specification ]
[HAVING search_condition ]
|