SQL: The difference between WHERE and HAVING

Re:SQL: The difference between WHERE and HAVING by gpvos on Tuesday December 14, 2021 @09:07AM (#29551604)

I was thinking more in terms of during than before or after. And that HAVING was part of the GROUP BY syntax, and could therefore not be used without it.

[ Parent | on HN ]

Re:SQL: The difference between WHERE and HAVING by frozenice on Tuesday December 14, 2021 @09:19AM (#29551739)

Think of it this way: there is always a GROUP BY (implicitly), i.e. GROUP BY rownum(). So there is always a big group with all the rows (or rather many small groups).

[ Parent | on HN ]