SQL queries that start with the
SELECT keyword and are often referred to as
statements. The Data Virtuality Server supports most of the standard SQL query constructs.
SELECT [DISTINCT|ALL] ((expression [[AS] name])|(group identifier.STAR))*|STAR ...
- Aliased expressions are only used as the output column names and in the
ORDER BYclause. They cannot be used in other clauses of the query;
DISTINCTmay only be specified if the
SELECTsymbols are comparable.