SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

S-18

SELECT Statement

SELECT is a DML statement that retrieves values from tables and views.

SELECT [ ALL | DISTINCT ] select-list

[ INTO :host-variable [ , :host-variable ] ... ]

FROM table-ref [ , table-ref ] ...

[| WHERE search-cond |]

[| |]

[| HAVING search-cond |]

[| |]

[| [ FOR ] { BROWSE | STABLE | REPEATABLE } ACCESS |]

[| |]

[| [ IN ] { SHARE | EXCLUSIVE } MODE |]

[| |]

[| GROUP BY { colname } [ collate ] |]

[| { colnum } |]

[| |]

[| ORDER BY { colname } [ASC[ENDING]] [ collate ] |]

[| { colnum } [DESC[ENDING] |]

[ UNION [ ALL ] select-statement ]

[ FOR UPDATE OF column-name [ , column-name ] ... ]

select-list is:

{ * } [ { * } ]

{ corr.* } [ { corr.* } ]

{ expr } [ { expr } ]

table-ref is:

{ table }

{ view } [ corr ]

{ join-table }

join-table is:

table-ref [ INNER ] JOIN table-ref ON search-cond

[ LEFT ]

collate is:

COLLATE { collation | CHARACTER SET }