🚀 go-pugleaf

EDDIE SHUM <econshum@netvigator.com> wrote:

>Say, for example, you have a SQL table containing data on name of
>students, Place of birth (like a given state in the US) and their text
>score.  Suppose you want to know what is the average score for students
>born in Kansas.  In your applicatin, you would normally carry out a
>filter with the help of the data button components provided by VDB7
>which are very good.  Now, you have a subset of your original rowset or
>a sub-rowset.  What is OODML function or command for doing sum, average,
>etc.?
>
>I have tried the "calculate aggregates" function in VDB7 and it always
>returns the result for the whole rowset and not a subset.  Could someone
>shed some light on this?

This is off the top of my head, but try something like:

select avg( somefield ) from tablename where bornInfield = 'Kansas' 

Ken
---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm

Please respond in the newsgroup unless explictly asked otherwise