odbtools/odbctest/mql/basic/11cncachedb/31.aggr.mql

insert into /test/测试缓存库 (字符串, 文本, 整数, 大整数, 浮点, 自定义类型, 双浮点, 布尔) values ('2', 'hhhhhh', 1, 1534567890123456789, 1.3, 2.1234567890123456, 1.223456, true  )
;

/**
sleep(1s)
**/
;

select count(*) from /test/测试缓存库 group by 字符串
/**
count(3)
**/
;

select sum(浮点), min(整数), max(自定义类型) , avg(整数) as avgint, 字符串 from /test/测试缓存库 group by 字符串
/**
count(3)
**/
;