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

[X Y]

Yes But even using a COUNT(*) does not return 1.

--- Gunnar Swan <GunnarSwan at practicetopass.com> wrote:
> This may make sense.
> Maybe put some logic, where if one record is
> returned,
> the results ARE ... the AVG/SUM.
> 
> In mathematics, this is a true statement.
> 
> 
> 3/14/03 12:05:12 PM, X Y <xyzabc1010 at yahoo.com>
> wrote:
> 
> >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
> >_______________________________________________
> >Valentina mailing list
> >Valentina at lists.macserve.net
>
>http://lists.macserve.net/mailman/listinfo/valentina
> >
> 
> 
> Best Regards,
> Gunnar Swan
> http://www.PracticeToPass.Com
> Software Built For Statutory Courses
> 
> 
> _______________________________________________
> 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