Clause list

<< Click to Display Table of Contents >>

Navigation:  Local SQL > Data Manipulation Language > Clauses >

Clause list

 Previous pageReturn to chapter overviewNext page

 

Local SQL supports the following SQL statement clauses:

Clause                Description

 

FROM        Specifies the tables used for the statement.
WHERE        Specifies filter criteria to limit rows retrieved.
ORDER BY        Specifies the columns on which to sort the result set.
GROUP BY        Specifies the columns used to group rows with aggregation.
HAVING        Specifies filter criteria using aggregated data.

Note: Not all of the above clauses are supported by all statements. See the topics for individual statements for specific indications of what clauses are and are not supported.