Multi column sql construct
From: Loh Kir Chern <mcblohkc_at_leonis.nus.sg>
Date: 1995/06/15
Message-ID: <3rosq4$j55_at_nuscc.nus.sg>#1/1
Date: 1995/06/15
Message-ID: <3rosq4$j55_at_nuscc.nus.sg>#1/1
Dear World,
I hope to construct a SQL statement that can produce a matrix sql result.
Example I have the following table :
Marks (Student Name, Subject, Marks) and wish to construct an SQL to get
the following "matrix" output :
Note that student Name (columns) and Subjects (Rows) changes year by year
as students and subjects changes. I wish to spool it to a file as an
ASCII file. I have only sql*plus as my tool.
Thanks for any advice.
Rgds
Student 1 Student 2 Student 3 ........
Subject 1 x1 x2 x3
Subject 2 y1 y2 y3
Subject 3 z1 z2 z3
:
:
:
Loh Kir Chern
(Email : mcblohkc_at_leonis.nus.sg)
Received on Thu Jun 15 1995 - 00:00:00 CEST