Re: Reports requirements -- Urgently needed

This might be a case for using the ROLLUP function in Oracle 8i

Have a look at the doco for examples of the use of ROLLUP

Looks like you have a couple of different "dimensions" i.e schools,class,students
something like this might do the trick...

SELECT class, school,
SUM(marks) AS Total Marks
FROM MARKS_TABLE
GROUP BY class,
ROLLUP(school)

Hope this helps

--
Posted via http://dbforums.com