What is CLAUSE?

SQL clause is defined to limit the result set by providing conditions to the query. This usually filters some rows from the whole set of records.

Example

Query that has WHERE condition

Query that has HAVING condition.