SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-174
SELECT Statement
SELECT Statement
Considerations for SELECT
Considerations for Select List
Considerations for SEQUENCE BY
Considerations for GROUP BY
Considerations for ORDER BY
Considerations for UNION
MXCI Examples of SELECT
C Examples of SELECT
COBOL Examples of SELECT
Publish/Subscribe Examples of SELECT
The SELECT statement is a DML statement that retrieves values from tables, views,
derived tables determined by the evaluation of query expressions, or joined tables.
The SELECT INTO statement is used to retrieve a single row of values from tables,
views, joined tables, or derived tables determined by the evaluation of query
expressions. It assigns the retrieved row of values to host variables. Use the INTO
version of SELECT only in embedded SQL programs.
[ROWSET FOR size-and-index ]
size-and-index is:
| INPUT SIZE rowset-size-in
| OUTPUT SIZE rowset-size-out
| KEY BY row-id
| INPUT SIZE rowset-size-in, OUTPUT SIZE rowset-size-out
| INPUT SIZE rowset-size-in, KEY BY row-id
| OUTPUT SIZE rowset-size-out, KEY BY row-id
| INPUT SIZE rowset-size-in, OUTPUT SIZE rowset-size-out,
KEY BY row-id
SELECT [[ANY N] | [FIRST N]] [ALL | DISTINCT] select-list
INTO variable-spec [,variable-spec]...
FROM table-ref [,table-ref]...
[WHERE search-condition | rowset-search-condition ]
[SAMPLE sampling-method]
[TRANSPOSE transpose-set [transpose-set]...
[KEY BY key-colname]]...
[SEQUENCE BY colname [ASC[ENDING] | DESC[ENDING]]
[,colname [ASC[ENDING] | DESC[ENDING]]]...]
[GROUP BY colname [,colname]...]
[HAVING search-condition | rowset-search-condition ]
[ORDER BY {colname | colnum} [ASC[ENDING] | DESC[ENDING]]
[,{colname | colnum} [ASC[ENDING] | DESC[ENDING]]]...]
[[FOR] access-option ACCESS]
[IN {SHARE | EXCLUSIVE} MODE]
[UNION [ALL] select-stmt]
Embed
Embed
Embed
Embed
Embed