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.