SELECT Clause
SQL queries starting with the SELECT
keyword are often referred to as
SELECT
statements. The Data Virtuality Server supports most of the standard SQL query constructs.
Usage
SQL
SELECT [DISTINCT|ALL] ((expression [[AS] name])|(group identifier.STAR))*|STAR ...
Syntax Rules
- Aliased expressions are only used as the output column names and in the
ORDER BY
clause. They cannot be used in other clauses of the query; DISTINCT
may only be specified if theSELECT
symbols are comparable.