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

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 the SELECT symbols are comparable.