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

Home -> Community -> Usenet -> c.d.o.misc -> tricky SQL

tricky SQL

From: bcjm <oldcar_at_hotmail.com>
Date: 3 Mar 2005 07:16:46 -0800
Message-ID: <1109863006.386175.88210@z14g2000cwz.googlegroups.com>


I have a table with 3 columns: Person, Class and grade. There are unlimited number of classes available but each person can only take 3 classes max. How do you right one SQL to show the list of class and grade of each person in one row?

Example: Table T

p1 c1 A
p1 c2 D
p1 c3 B
p2 c5 B
p3 C1 A
p3 C8 C
...
...

SQL result
P1 C1 A C2 D C3 B
P2 C5 B
P3 C1 A C8 C Received on Thu Mar 03 2005 - 09:16:46 CST

Original text of this message

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