Difference between Where and Having clause in SQL

Both Where and Having clauses are used for filtering data. Where clause is used to filter rows based on conditions applied to columns in the dataset before any grouping, having Clause is used in conjunction with the group by clause when you want to filter the result of aggregated data.