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.