AX / Dynamics 365 For Finance and Operations blog

Thiis simple code shows how to do a Query using a select statement with GROUP BY clause and Aggregate functions like COUNT, SUM, AVG, etc..

CustTable custTable;
    
    while select count(RecId), CustGroup from custTable
        group by CustGroup
        order by custTable.RecId desc
        
    {
        info(strFmt("%2 - %1", custTable.RecId, custTable.CustGroup));
    }