Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: tricky SQL
"bcjm" <oldcar_at_hotmail.com> wrote in
news:1109863006.386175.88210_at_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
>
>
By taking better notes in class, reading your course book or asking the instructor for assistance. Received on Thu Mar 03 2005 - 09:34:21 CST