1.UNION ALL
SELECT SUM(one) ,two FROM
(SELECT 1 one, 3 two FROM dual
UNION ALL
SELECT 3, 5 FROM dual
UNION ALL
SELECT 4, 3 FROM dual)
GROUP BY two
1.UNION ALL
SELECT SUM(one) ,two FROM
(SELECT 1 one, 3 two FROM dual
UNION ALL
SELECT 3, 5 FROM dual
UNION ALL
SELECT 4, 3 FROM dual)
GROUP BY two