Where clause has a comparison predicate that restricts the number of rows as per the user-generated query. This clause should be applied before the GROUP BY clause. This clause functions with the help of a comparison predicate, when a comparison predicate does not evaluate a result to be true, all rows from the end result are deleted.