SQL Statements for Flat-File Drivers : Select Statement

Select Statement
The form of the Select statement supported by the flat-file drivers is:
SELECT [DISTINCT] {* | column_expression, ...}
FROM table_names [table_alias] ...
[ WHERE expr1rel_operatorexpr2 ]
[ GROUP BY {column_expression, ...} ]
[ HAVING expr1rel_operatorexpr2 ]
[ UNION [ALL] (SELECT...) ]
[ ORDER BY {sort_expression [DESC | ASC]}, ... ]
[ FOR UPDATE [OF {column_expression, ...}] ]
Select Clause
From Clause
Where Clause
Group By Clause
Having Clause
Union Operator
Order By Clause
For Update Clause
SQL Expressions

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.