Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Tricky Sql Question

Tricky Sql Question

From: dmarsha3 <dmarsha3_at_csc.com>
Date: 30 Apr 1998 15:36:49 GMT
Message-ID: <6ia5qh$323@explorer.csc.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US