SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

row_number() over(partition by

hemant_kJul 11 2008 — edited Jul 11 2008

select decode(row_number() over(partition by a order by a),1, a) a, b, sum(del) del, sum(kol) kol, sum(viz) viz
22 from (select a,b,c,decode(c, 'kol', d) kol, decode(c,'del',d) del, decode(c,'viz',d) viz from t order by a, b, c)
23 group by a,b

where can i find documentation for this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 8 2008

Added on Jul 11 2008

2 comments

2,068 views