Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with select statement (pivot table?)
ak_tiredofspam_at_yahoo.com wrote:
> use an alias for the rownum from the inline view:
>
> select year, account, rn, sum(decode(rn, 1, Period1, 2,
> Period2, 3, Period3, 4, Period4, 5, Period5, 6, Period6, 7, Period7,
8,
>
> Period8, 9, Period9, 10, Period10, 11, Period11, 12, Period12)) from
> table1, (select rownum rn from all_objects where rownum <=12) group
by
> year, account
OK. I got it to sum. Below is the actual sql being used.
SELECT GLM_FY, GLM_KEY, GLM_OBJ, sum(case when rownum between 1 and 7 then (decode( rownum, 1, GLM_MO_BUDGET01, 2, GLM_MO_BUDGET02, 3,
GLM_MO_BUDGET03, 4, GLM_MO_BUDGET04, 5, GLM_MO_BUDGET05, 6, GLM_MO_BUDGET06, 7, GLM_MO_BUDGET07, 8, GLM_MO_BUDGET08, 9, GLM_MO_BUDGET09, 10, GLM_MO_BUDGET10, 11, GLM_MO_BUDGET11, 12, GLM_MO_BUDGET12)) end)
![]() |
![]() |