3 ms·
Yeah, you are correct it's really just syntactic sugar for that. As another comment points out, WHERE and HAVING are just σ in relational algebra.
by throwawayffffas 5y ago
Yeah, you are correct it's really just syntactic sugar for that. As another comment points out, WHERE and HAVING are just σ in relational algebra.
- maweki 5y agoIn 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.