SELECTSUM(CASE VAL WHEN 1 THEN 1 ELSE 0 END ) AS "1"
,SUM(CASE VAL WHEN 2 THEN 1 ELSE 0 END ) AS "2"
,SUM(CASE VAL WHEN 3 THEN 1 ELSE 0 END ) AS "3"
FROM
GROUP_TEST;
SELECTSUM(DECODE( VAL, 1, 1, 0, 0 ) AS "1"
,SUM(DECODE( VAL, 2, 1, 0, 0 ) AS "2"
,SUM(DECODE( VAL, 3, 1, 0, 0 ) AS "3"
FROM
GROUP_TEST;
CUBE集計
SELECTSUM(CASE VAL WHEN 1 THEN COUNT(*) ELSE 0 END) AS "値1"
,SUM(CASE VAL WHEN 2 THEN COUNT(*) ELSE 0 END) AS "値2"
,SUM(CASE VAL WHEN 3 THEN COUNT(*) ELSE 0 END) AS "値3"
,SUM(CASE VAL WHEN 4 THEN COUNT(*) ELSE 0 END) AS "値4"
,SUM(CASE VAL WHEN 5 THEN COUNT(*) ELSE 0 END) AS "値5"
,SUM(CASE VAL WHEN 6 THEN COUNT(*) ELSE 0 END) AS "値6"
,SUM(CASE VAL WHEN GROUPING(VAL) THEN COUNT(*) ELSE 0 END) AS "合計"
FROM
GROUP_TEST
GROUP BY CUBE ( VAL );