SELECT [ ALL | DISTINCT ] [ FIRST | TOP n ] select-list ...[ INTO { host-variable-list | variable-list } ] ...[ FROM table-list ] ...[ WHERE search-condition ] ...[ GROUP BY column-name | alias | function ... ] ...[ HAVING search-condition ] ...[ ORDER BY { expression | integer } [ ASC | DESC ], ... ]
...[ INTO { host-variable-list | variable-list } ]
...[ FROM table-list ]
...[ WHERE search-condition ]
...[ GROUP BY column-name | alias | function ... ]
...[ HAVING search-condition ]
...[ ORDER BY { expression | integer } [ ASC | DESC ], ... ]