SQL Language Guide : 8. SQL Statements : SELECT (Interactive)
 
Share this page                  
SELECT (Interactive)
Valid in: SQL, ESQL, DBProc, OpenAPI, ODBC, JDBC, .NET
The SELECT (interactive) statement returns values from tables or views.
Notes:
SELECT queries that access both Vector and standard Ingres tables cannot execute.
Similarly, INSERT...SELECT and CREATE AS SELECT do not work if the SELECT statement references both Vector and Ingres tables.
This statement has the following format:
[WITH common_table_expression]
SELECT [FIRST rowCount] [ALL | DISTINCT] * | expression [AS result_column]
              {, expression [[AS] result_column]}
              [FROM from_source {, from_source}
              [WHERE search_condition] WHERE (clause)
              [GROUP BY [ALL | DISTINCT] grouping element {, grouping element}]
              [HAVING search_condition] HAVING (clause)
              {UNION [ALL] | INTERSECT | EXCEPT
              (select)}
              [ORDER BY ordering-expression [ASC | DESC]
                            {, ordering-expression [ASC | DESC]}
                                [NULLS {FIRST | LAST}]];
              [OFFSET n]
              [FETCH FIRST|NEXT n ROWS|ROW ONLY]
              [WITH options]
Syntax elements are described in WITH common table expression (see WITH (common_table_expression)) and SELECT Statement Clauses.