できるPRO MySQL できるPROシリーズ Kindle版の内容をまとめる。
AS
句列名 AS 別名
SELECT Continent, SUM(Population) AS TotalPop FROM country
GROUP BY Continent WITH ROLLUP;
MariaDB [world]> SELECT Continent, SUM(Population) AS TotalPop FROM country GROUP BY Continent WITH ROLLUP;
+---------------+------------+
| Continent | TotalPop |
+---------------+------------+
| Asia | 3705025700 |
| Europe | 730074600 |
| North America | 482993000 |
| Africa | 784475000 |
| Oceania | 30401150 |
| Antarctica | 0 |
| South America | 345780000 |
| NULL | 6078749450 |
+---------------+------------+
8 rows in set (0.01 sec)