When to use group by in select statement of ax 2012

Hi,

When to use group by in select statement of ax 2012.Whats is its purpose??/Should it be used only in while select statement ???.Please clear this doubt???

Thanks in Advance

Whenever you want to group records by some field(s). It’s usually used together with aggregation functions, e.g. count() or sum().

For example, you may want to get number of customers grouped by customer group.

This is nothing specific to AX; it’s a part of SQL.

Thanks Martin [:)]