Re: Compute in Oracle
From: maya <maya_java_at_yahoo.com>
Date: 22 Feb 2005 14:20:33 -0800
Message-ID: <1109110833.849444.149350_at_f14g2000cwb.googlegroups.com>
Date: 22 Feb 2005 14:20:33 -0800
Message-ID: <1109110833.849444.149350_at_f14g2000cwb.googlegroups.com>
[Quoted] Yes, with Oracle 9i and using sqlplus reports
and we use sqlplus compute/break commands
as an example:
Principal Teacher Name STUDNAME co' su' Percent ----------- -------------- ------------ -------- --- --- --- PRINCIPAL1 teach1 stud1 7 [Quoted] 5 71 PRINCIPAL1 teach1 stud2 4 [Quoted] 3 75 PRINCIPAL1 teach1 Average 11 [Quoted] 8 72.73 [this one] PRINCIPAL1 teach2 stud1 9 5 71 PRINCIPAL1 teach2 stud2 3 3 75 PRINCIPAL1 teach2 Average 12[Quoted] 8 66.67 [this one]
here 72.73 and 66.67 etc are the values
Total co and su are dispayed using compute and avg should be calculated
[Quoted] from these totals and displayed at the position shown.
Hopefully it helps Received on Tue Feb 22 2005 - 23:20:33 CET