mirror of
https://github.com/hanzo-ds/sqlparser.git
synced 2026-10-30 20:53:50 +00:00
21 lines
265 B
SQL
21 lines
265 B
SQL
SELECT
|
|
datacenter,
|
|
distro,
|
|
SUM (quantity) AS qty
|
|
FROM
|
|
servers
|
|
GROUP BY
|
|
GROUPING SETS(
|
|
(datacenter,distro),
|
|
(datacenter),
|
|
(distro),
|
|
()
|
|
);
|
|
|
|
SELECT
|
|
datacenter,
|
|
distro,
|
|
SUM (quantity) AS qty
|
|
FROM
|
|
servers
|
|
GROUP BY ALL; |