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!

Horizontal group by date

Lorenz-OracleMay 1 2007 — edited May 1 2007

I like to sum up and group my customer orders by year.
It would be great if somebody could help!
Kind regards.........Lorenz

Expected result:
CUST_ID 2005 2006 2007
138 - 64,7 258,7
401 96,9 646,4 228,9

Sample Data
ORDER_ID ORDER_TOTAL ORDER_DATE CUST_ID
321 258,7 21.03.07 138
124 96,9 02.08.05 401
324 196,9 18.07.06 401
525 449,5 11.10.06 401
361 64,7 09.01.06 138
523 228,9 04.02.07 401

Locked Post

New comments cannot be posted to this locked post.

Locked on May 29 2007

Added on May 1 2007

3 comments

295 views