group by

Former Member — Sun, 23 Dec 2007 09:18:45 GMT

Can sum statement be used in reports instead of the “ group by “ statement?

Re: group by

Former Member — Wed, 26 Dec 2007 12:15:45 GMT

Hi,

You use GROUP BY when you want to make use of aggregate operations eq min( ), max( ), sum ( ) etc.

eg select a b sum( c )

from mytable

group by a b

Each field in the select statement either needs to be listed in the GROUP BY clause, or have an aggregate function applied to it.

Kindly Award Points If You Find The Reply Helpful.

Cheers,

Chaitanya.