できるPRO MySQL できるPROシリーズ Kindle版の内容をまとめる。
HAVING
句SELECT Continent, SUM(Population) AS TotalPop
FROM country
GROUP BY Continent
HAVING TotalPop > 2000000;
MariaDB [world]> SELECT Continent, SUM(Population) AS TotalPop FROM country GROUP BY Continent HAVING TotalPop > 2000000;
+---------------+------------+
| Continent | TotalPop |
+---------------+------------+
| Asia | 3705025700 |
| Europe | 730074600 |
| North America | 482993000 |
| Africa | 784475000 |
| Oceania | 30401150 |
| South America | 345780000 |
+---------------+------------+
6 rows in set (0.06 sec)
SELECT Continent, SUM(Population) AS TotalPop
FROM country
WHERE population > 2000000
GROUP BY Continent;
MariaDB [world]> SELECT Continent, SUM(Population) AS TotalPop FROM country WHERE population > 2000000 GROUP BY Continent;
+---------------+------------+
| Continent | TotalPop |
+---------------+------------+
| Asia | 3699111000 |
| Europe | 725309200 |
| North America | 478854000 |
| Africa | 771749000 |
| Oceania | 27555000 |
| South America | 344319000 |
+---------------+------------+
6 rows in set (0.01 sec)