SQL Guide : solidDB® SQL statements : Common clauses : query_specification
  
query_specification
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 ]
See also
Common clauses