SQL Reporting problem
From: S.A.Milward <smilward_at_cen.ex.ac.uk>
Date: Tue, 28 Feb 1995 09:45:34 GMT
Message-ID: <D4pF3y.I0n_at_exeter.ac.uk>
Date: Tue, 28 Feb 1995 09:45:34 GMT
Message-ID: <D4pF3y.I0n_at_exeter.ac.uk>
I wonder if anyone can help me with an SQL query. I have a simple table of the format:
A B Size
- -- --- 60 35 200 50 36 300 70 35 400 50 35 200 60 36 300 70 36 400
I need to produce a report (using SQL*Plus only) in the format:
200 300 400
- --- --- A 55 55 70 B 35 36 35.5
ie the values of Size are averaged for A and B and the table is then flipped over so that each row becomes a column and vice versa.
I would be very grateful for any suggestions - please reply by e-mail.
Sue Milward
Exeter University
S.A.Milward_at_ex.ac.uk
Received on Tue Feb 28 1995 - 10:45:34 CET