Neoview SQL Reference Manual (R2.5)

SELECT Statement
• “Syntax Description of SELECT”
• “Considerations for SELECT”
• “Considerations for Select List”
• “Considerations for SEQUENCE BY”
• “Considerations for GROUP BY”
• “Considerations for ORDER BY”
• “Considerations for UNION”
• “Examples of SELECT”
The SELECT statement is a DML statement that retrieves values from tables, views, and derived
tables determined by the evaluation of query expressions, or joined tables.
sql-query is:
query-specification
| query-expr-and-order
query-specification is:
SELECT [[ANY N] | [FIRST N]] [ALL | DISTINCT] select-list
FROM table-ref [,table-ref]...
[WHERE 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 | colnum} [,{colname | colnum}]...]
[HAVING search-condition]
[access-clause ]
[mode-clause]
query-expr-and-order is:
query-expr [order-by-clause] [access-clause] [mode-clause]
query-expr is:
query-primary
| query-expr UNION [ALL] query-primary
query-primary is:
simple-table | (query-expr)
simple-table is:
VALUES (row-value-const) [,(row-value-const)]...
| TABLE table
| query-specification
row-value-const is:
row-subquery
| {expression | NULL} [,{expression | NULL}]...
164 SQL Statements