It is the source of a rowset to be operated upon in a DML statement. These clauses are very common which is used with Select statement, Update statement and Delete statement.

SQL provides with the following clauses that are given below:

  • WHERE
  • GROUP BY
  • HAVING
  • ORDER BY etc
BY Best Interview Question ON 13 Jan 2019