In T-SQL I can accumulate the results of two unioned queries using the following syntax:
SELECT Q.a, SUM(Q.b) FROM ( SELECT f1 as a, f2 as b FROM TBL1 UNION ALL SELECT f1 as a, f2 as b FROM TBL2 ) GROUP BY Q.a
What is the equivalent in Oracle?
closed as off-topic by Paul White♦ Aug 27 at 17:21
This question appears to be off-topic. The users who voted to close gave this specific reason:
Assuming that you alias the inline view to