Question · SQL and MySQL course · Module 6: Aggregation and grouping
WHERE/HAVING rule of thumb
The condition concerns an ordinary column: dostepna = 1. Which clause should you use?
Answer options
- WHERE, because the condition concerns individual rows, not an aggregate
- HAVING, because every condition requires HAVING
- Both at once, otherwise the query will not work
- GROUP BY, because it is a grouping condition
You can check the correct answer by solving this task in the CodeWorlds game.