Basic SQL queries
The SELECT statement retrieves rows from the database and allows the selection of one or more rows or columns from one table.
Syntax
SELECT
[ ALL | DISTINCT ]
{ * | expression [ [ AS ] column_alias ]
[, * | expression [ [ AS ] column_alias ]... ] }
FROM
table
[ WHERE
expression ]
[ GROUP BY
expression [, expression... ] ]
[ ORDER BY
{ expression } [ ASC | DESC ]
[,{ expression } [ ASC | DESC ]... ] ]
Notes
The supports
SELECT only from a single table and does not support the
INTO and
UNION clauses. Table aliases are not supported. However, you can use the
table.column_name convention when specifying select columns. This means that queries generated by query builders will run against the OLE DB Provider. For information on queries on
HDATA, see
Hierarchical SQL queries.