group by

[Former Member]

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

[Former Member]

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.

[Former Member]

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.