Free Chapter
The HAVING clause is used to filter the GROUP BY results. The following code shows the HAVING syntax, where the WHERE and ORDER BY clauses are optional:
SELECT column(s)
FROM table
WHERE condition(s)
GROUP BY columns(s)
HAVING condition(s)
ORDER BY column(s);
Let's say you needed to see the results of running the GROUP BY clause in the previous section, but where the sum of at-bats is greater than 100. This is when you would use a HAVING clause, as shown in the following query:
USE lahmansbaseballdb;
SELECT playerid, teamid, sum(AB) AS sum_at_bats
FROM batting
GROUP BY playerid, teamid
HAVING sum_at_bats > 100;
The following screenshot...
