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!

grouping multiple rows into a single row

444852May 12 2009 — edited May 12 2009

I totally need some help with this simple task... Basically, I have multiple rows for a single user id that I need to be grouped into a single row.

The following is what I have before:

USERID MONTH1_SEVERITY MONTH2_SEVERITY MONTH3_SEVERITY

1900055 MODERATE
1900055< ....ignore just space..>MODERATE
1900055<.......ignore just space.............................>MODERATE

What I would like to see:
USER_ID MONTH1_SEVERITY MONTH2_SEVERITY MONTH3_SEVERITY

1900055 MODERATE MODERATE MODERATE

Thanks in advance.

This post has been answered by Ritesh Singh on May 12 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 9 2009

Added on May 12 2009

2 comments

458 views