ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-83
SELECT
The SELECT statement has the following syntax:
SELECT { ALL } select-list
{ DISTINCT }
[ INTO [ [database.]owner. ] table-name) ]
FROM table-reference [ correlation-name ] [ HOLDLOCK ]
[, table-reference [ correlation-name ] [ HOLDLOCK ] ] ...
[ WHERE search-condition ]
[ GROUP BY [ ALL ] agg-free-expr [ , agg-free-expr ] ... ]
[ HAVING search-condition ]
[ ORDER BY sort-spec [ , sort-spec ] ... ]
[ COMPUTE comp-list BY column-name [ , column-name ] ... ]
[ FOR BROWSE ]
select-list is:
select-item [ , select-item ] ...
select-item is:
{ [table-reference.]* }
{ [table-reference.]column-name }
{ column-heading = [table-reference.]column-name }
{ [table-reference.]column-name column-heading }
{ expression }
{ aggregate-function }
agg-free-expr is:
{ column-name }
{ expression }
sort-spec is:
{ [table-reference.]column-name } [ ASC ]
{ select-list-number } [ DESC ]
{ expression }