• Where clause can be applied to a single row, where as Having clause is applied to the whole group.
  • Having clause is used, when we want to use select query to filter data from a table based on a aggregate condition