What is CLAUSE?

SQL clause is defined to limit the result set by providing condition 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.