Skip to main content

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.
FeedbackOpens in a new tab