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.
• WITH – A clause to specify Common Table Expressions which allow a subquery to be easily used within a main query.