Having vs. Where clause

In SQL, what’s the difference between the having clause and the where clause? The difference between the having and where clause is best illustrated by an example. Suppose we have a table called emp_bonus as shown below. Note that the table has multiple entries for employees A and B. emp_bonus Employee Bonus A 1000 B … Continue reading Having vs. Where clause