having is less annoying way of not doing needless/bug-prone repetition. if you selectsomeCalculatedValue(someInput) as lol you can add having lol >42 in mysql, whereas without (ie in pgsql) you’d need to do where someCalculatedValue(someInput) > 42, and make sure changes to that call stay in sync despite how far apart they are in a complex sql statement.
having is less annoying way of not doing needless/bug-prone repetition. if you
select someCalculatedValue(someInput) as lol
you can addhaving lol > 42
in mysql, whereas without (ie in pgsql) you’d need to dowhere someCalculatedValue(someInput) > 42
, and make sure changes to that call stay in sync despite how far apart they are in a complex sql statement.