SELECT [DISTINCT|ALL] ((expression [[AS] name])|(group identifier.STAR))*|STAR ...
SQL queries that start with the
SELECT keyword and are often referred to as SELECT statements.
YOu can use most of the standard SQL query constructs in Teiid.
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.