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

[Gunnar Swan]

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