[belugin]

X++

Table1 table1;
select maxOf(field2) group by field1;

Query:

Query q=new Query();
QueryBuildDataSource ds=q.addDataSource(tableNum(Table1));
;
// теперь сортировка группиоует
ds.orderMode(OrderMode::GroupBy);
ds.addSelectionField(fieldNum(Table1, Field2), SelectionField::Max);
ds.addSortField(fieldNum(table1, Field1);

SYS_ExpressionQueryBuilder

    QueryRun qr=SYS_ExpressionQueryBuilder::addDataSource(tableNum(LedgerTrans))
        .max(fieldNum(LedgerTrans, Qty))
        .groupBy(fieldNum(LedgerTrans, AccountNum))
    .run();