News for hackers. Stuff that matters.

A comment on SQL: The difference between WHERE and HAVING. Parent comment

Re:SQL: The difference between WHERE and HAVING by FedericoRazzoli on Tuesday December 14, 2021 @12:50PM (#29554694)
You are correct, HAVING is essentially syntax sugar. But to be fair, I'm glad it exists.
[ Parent | on HN ]
Re:SQL: The difference between WHERE and HAVING by tgv on Tuesday December 14, 2021 @12:59PM (#29554844)
Sure, and I remember the version of mySQL that didn't have sub-queries. Having HAVING has your back, then.
[ Parent | on HN ]