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!

Reverse of group by...

NapsterDec 6 2010 — edited Dec 7 2010

Hi Guys...

I have the following output...

Select code, qty from Mytable;

code  qty
A     1
B     2
C     1

But I am looking for a output like below...

code  qty
A     1
B     1
B     1
C     1

Kind of reverse of group by...

Thanks...

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2011

Added on Dec 6 2010

9 comments

3,157 views