I don't think you can do this with a straight sum(whatever) sql
statement, but 'select * from StudentScore ('eng') might do
it and more .. id expanded a bit, like class average for each
student per subject

create procedure StudentScore (Subject MyVarText(4) )
returns (Name VarChar(20),
Score Integer,
Subject VarChar(4),
ValueTotal Integer))
as
begin
ValueTotal = 0;

Select Name,Sum(Score),Subject from TableStudentScores
Group by Name,Subject
Order ny Name,Subject
into :Name,
:Score,
:Subject
do
begin
ValueTotal = ValueTotal + Score;
Suspend;
end
end

----------------------------------------------------------------------------
-----------

----- Original Message -----
From: <dorst622@...>
Newsgroups: egroups.ib-support
To: <ib-support@yahoogroups.com>
Sent: Monday, January 06, 2003 7:28 PM
Subject: [ib-support] SQL STATEMENT.HOW TO?


> I got this records
>
> seq name score subject
> 1 tom 10 eng
> 2 jimmy 11 eng
> 3 wendy 8 eng
> 4 mandy 5 eng
> 5 tom 5 math
> 6 wendy 4 math
> 7 jimmy 9 math
>
>
> what sql statement to used if i want to receive this result.
> valuetotal is the cumulative of value score
>
> seq name score subject valuetotal
> 1 tom 10 eng 10
> 2 jimmy 11 eng 21
> 3 wendy 8 eng 29
> 4 mandy 5 eng 34
>
> dorst622@...
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>