Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SQL help!
I need to return a result set for this year/last year data.. all from
the same table..
I need the information in the same line..
How do I do this in Oracle?
SELECT week_nbr,
week_dsc, store_nbr, store_name, sum(nvl(regsales,0)) as ty_reg_sales, null, sum(nvl(regunits,0)) as ty_reg_units, null, sum(nvl(promosales,0)) as ty_promosales, null, sum(nvl(promounits,0)) as ty_promounits, null
UNION SELECT week_nbr,
week_dsc, store_nbr, store_name, null, sum(nvl(regsales,0)) as ly_reg_sales, null, sum(nvl(regunits,0)) as ly_reg_units, null, sum(nvl(promosales,0)) as ly_promosales, null, sum(nvl(promounits,0)) as ly_promounitsFROM RSNET.JC_STORE_BY_WEEK
The nulls are there as place holders so the other query can fill the value...
suggestions?
-Ken
Received on Mon Jul 19 1999 - 08:24:36 CDT
![]() |
![]() |