>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.