Select Statement

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