SQL Clauses

DISTINCT – A SELECT clause that specifies to return only distinct values.
FROM – A SELECT clause that specifies one or more tables to query.
GROUP BY – A SELECT clause that groups the resulting rows of a query according to one or more columns.
HAVING – A SELECT clause that specifies one or more restrictive conditions on a group of data values.
INTO – A SELECT clause that specifies the storing of selected values in host variables.
ORDER BY – A SELECT clause that specifies the sorting of rows in a result set.
TOP – A SELECT clause that specifies how many rows to return.
UNION – Combines two or more SELECT statements.
VALUES – An INSERT/UPDATE clause that specifies data values for use in fields.
WHERE – A SELECT clause that specifies one or more restrictive conditions.
WHERE CURRENT OF – An UPDATE/DELETE clause that specifies the current row using a cursor.