| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: rownum & group by question
yippe ... I ended up adding the rownumber to my inline table.
this allowed me to take it out of the group-by. THEN, I pivoted.
select 1,
sum(case b.pos when 1 then b.amt end) amt,
sum(case b.pos when 2 then b.amt end) amt2
from
(
select rownum as pos, a.* from <----
(
...
...
before-mentioned query Received on Wed Mar 22 2006 - 11:20:50 CST
 |
 |