The HAVING clause is evaluated before the SELECT so you have to specify the full... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

atarashi on Feb 9, 2018 | parent | context | favorite | on: Advanced SQL window function quiz

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 on Feb 9, 2018 [–]

Yes, SQL engines tend to be much smarter than the SQL languages as such.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact