SQL Clauses

DISTINCT – A SELECT clause that specifies to return only distinct values.
EXCEPT – Returns results that are in the first specified query, but not in the second specified query.
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.
INTERSECT – Returns results that are in both of the specified queries.
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.
WITH – A clause to specify Common Table Expressions which allow a subquery to be easily used within a main query.