CODEWITHSUNDEEP
sqloracle-database
Ewaver
Ewaver

Reputation: 1191

Oracle SQL Cumulative Sum with Identifying Column values

I am using Oracle SQL and I am trying to combine two tables with Sums using a Union All, but I would like to identify the two returned rows as "LIVE" AND "ACTUALS". My queries are structured like this...

select
SUM(JAN_2014) as JAN_14,
SUM(FEB_2014) AS FEB_14,
SUM(MAR_2014) AS MAR_14
from table A

union all

select
SUM(JAN_2014) as JAN_14,
SUM(FEB_2014) AS FEB_14,
SUM(MAR_2014) AS MAR_14
from table B

The output I would like would be....

DATA_VIEW  JAN_14  FEB_14  MAR_14
ACTUALS    10      15      20
LIVE       20      20      20

Thanks for your help,

Upvotes: 0

Views: 257

Answers (1)

Lamak
Lamak

Reputation: 70668

SELECT  'ACTUALS' AS DATA_VIEW,
        SUM(JAN_2014) as JAN_14,
        SUM(FEB_2014) AS FEB_14,
        SUM(MAR_2014) AS MAR_14
FROM tableA

UNION ALL

SELECT  'LIVE' AS DATA_VIEW,
        SUM(JAN_2014) AS JAN_14,
        SUM(FEB_2014) AS FEB_14,
        SUM(MAR_2014) AS MAR_14
FROM tableB

Upvotes: 2

Related Questions