9 ms·
The HAVING clause is evaluated before the SELECT so you have to specify the full clause `having sum(weight) > 12` and not just the alias. Most SQL engines are p
by atarashi 9y ago
The HAVING clause is evaluated before the SELECT so you have to specify the full clause `having sum(weight) > 12` and not just the alias. Most SQL engines are probably smart enough to not actually recalculate everything.
- cema 9y agoYes, SQL engines tend to be much smarter than the SQL languages as such.