Skip to main content
Skip table of contents

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

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.