Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Tricky Sql Question
Group :
I have a table junk_tab(text,num,qty)
Text num Qty
A 1 5 B 2 5 C 3 5 A 1 4 B 2 4 E 1 6 F 2 6
and I would like to have a result like
ABC 5
AB 4 EF 6
Could somebody give a tip,direction or solution for this problem.
Thanks in advance
rama
rkolluru_at_csc.com
Received on Thu Apr 30 1998 - 10:36:49 CDT
![]() |
![]() |