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 maweki on Tuesday December 14, 2021 @09:43AM (#29552025)
In that sense, HAVING and WHERE being different is basically a "free" subquery without allowing subqueries.

One inner σ (WHERE) and one outer σ (HAVING).

If subqueries are allowed, then you don't need that.

[ Parent | on HN ]

There are no comments on this comment yet.