odbtools/odbctest/mql/basic/10basic/31.aggr.mql

insert into /test/basic (v_varchar, v_text, v_int, v_bigint, v_float, v_double, v_smalldouble, v_bool) values ('2', 'hhhhhh', 1, 1534567890123456789, 1.3, 2.1234567890123456, 1.223456, true  )
;

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

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

select count(*) as c,v_varchar as a from /test/basic group by v_varchar having count(*)>1
/**
output()
count(1)
**/
;

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