Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Elements and Statements in Backus Naur Form : Data types syntax in BNF : Query Expressions syntax in BNF : Query expression : Query specification
 
Query specification
query_specification ::=
SELECT [ ALL | DISTINCT ][top_specification]{ *
|{table_name. |alias.}* [, {table_name.|alias.}* ] ,...
| expr [[ AS ][ ']column_title[' ]]
[, expr [[ AS ][ ']column_title[' ]]] ,...}
FROM table_ref[, table_ref]...
[ WHERE search_condition]
[ GROUP BY [ table.]column_name[, [ table.]column_name] ,...
[ HAVING search_condition][WITH locking_hints][order_by_specification][offset-fetch specification];