Form 4.5 : Display of Sum,avg only

[ Article crossposted from comp.databases.oracle.tools ]
[ Author was Alan Kong ]
[ Posted on 9 Oct 1997 07:37:11 GMT ]

Hi,

I would like to create a form which only displays a listing of Sum and average of values and seeking your advise on this.

There are 2 tables:

	student: studno, name
	results: studno, year, subject, marks

Example of records in "results":
	studno		year	subject	 marks
	*******		****	******	 *****         
	s951234		1995	cs101	 2.5
	s951234		1995	cs102	 2.8
	s951234		1996	cs202	 2.6
	s951237		1995	cs101	 2.1
	...	etc		.....

The display in the form(in descending order of avg):

	studno		name	year	sum(marks)	avg(marks)
	*******		****	****	*********	*********
	s951234		John	1995	5.3		2.7	
	s951237		Jack	1995	6.0		2.4
	...	etc	...

I wonder whether it is a good solution to create a view, a temp view or temp table and then base on sql on the view to achieve this.

If not, what is the other method? Thanks.

--
Regards

Alan



*****************************************************************************

Alan, Kwok-Kee KONG                    | Email: kkkong_at_ee.cuhk.hk
Department of Electronic Engineering   |          alan_at_ee.cuhk.hk
The Chinese University of Hong Kong    | Tel:   +852 2609-8286 (voice)
Shatin, N.T.                           |        +852 2603-5558 (fax)
Hong Kong


*****************************************************************************


--
Regards

Alan



*****************************************************************************

Alan, Kwok-Kee KONG                    | Email: kkkong_at_ee.cuhk.hk
Department of Electronic Engineering   |          alan_at_ee.cuhk.hk
The Chinese University of Hong Kong    | Tel:   +852 2609-8286 (voice)
Shatin, N.T.                           |        +852 2603-5558 (fax)
Hong Kong


*****************************************************************************