{CodeRoyale}
All challenges
Multiple ChoiceIntermediate 30s

HAVING vs WHERE

Choose the best answer for: HAVING clause
Options
  1. 1WHERE filters after the aggregation and HAVING filters the rows
  2. 2HAVING filters aggregated results; WHERE filters rows before aggregation
  3. 3HAVING is for sorting the aggregated result by a chosen key
  4. 4They are identical and either clause can be swapped freely
backendintermediate

Think you can answer under pressure?

Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.

Play this in a 3-minute battle