odbtools/odbctest/mql/basic/11cacheonly/32.aggr2.mql

select * from /test/cacheonly
/**
output()
count(4)
**/
;

select count(*) from /test/cacheonly group by v_varchar
/**
output()
count(3)
**/
;

select sum(v_float), min(v_int), max(v_double) , avg(v_int) as avgint, v_varchar from /test/cacheonly group by v_varchar
/**
count(3)
**/
;