Both filters out records based on one or more conditions. The diff is "where" can only be applied on static non aggregated column whereas having is for aggregated columns.