HAVING clause syntax in Google Bigquery
The HAVING clause is similar to the WHERE clause: it filters out rows that do not return TRUE when they are evaluated against the bool_expression.
- The HAVING clause differs from the WHERE clause in that:
- The HAVING clause occurs after GROUP BY and aggregation, and before ORDER BY. This means that the HAVING clause is evaluated once for every aggregated row in the result set. This differs from the WHERE clause, which is evaluated before GROUP BY and aggregation
SELECT LastName, SUM(PointsScored) AS ps
GROUP BY LastName
HAVING ps > 0;
Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds