Fwd: Re: [V4MD] problem w/ Group By

[X Y]

Yes I have changed my field type from integer to
floats. However, if there exists only a single record
in the db, then the AVG/SUM doesnt return anything.

--- Gunnar Swan <GunnarSwan at practicetopass.com> wrote:
> 
> 
> >In addition, if I have only one record in the db
> and
> >use an AVG or SUM or COUNT, nothing gets return. 
> 
> I had a problem where integers were not summed.
> When I switched to a float or a long, it summarized.
> 
> >
> >SELECT name, SUM(val) FROM A WHERE name = 'foo'
> GROUP
> >BY NAME
> >
> 
> I think too, you have to have an ORDER BY when you
> use a GROUP BY.
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina


__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com