WHERE and HAVING clauses.WHERE and HAVING clauses filter data and restrict unwanted data from appearing in your result set. The main difference between these filters is :WHERE is applied at the record level.HAVING is applied to sets of records.