odbtools/odbctest/mql/0/aggr/1.mql

select count(*) as count from /test/sequence where v_int >= 1.1
/**
output()
count(1)
**/
;

select id,email,username,parent,grpset,lft,rgt,otype,isactive from /matrix/ldap
/**
output()
**/
;

#/matrix/ldap | group by parent
/**
output()
match('groupby.0',"parent")
match('groups.0.__nil__.0.class',"/matrix/ldap")
**/
;

select count(*) from /matrix/ldap where username='admin'
/**
output()
count(1)
**/
;

select parent,count() from /matrix/ldap group by parent having count()=1
/**
output()
match('count', 1)
**/
;

select parent,count() from /matrix/ldap group by parent
/**
output()
match('parent', "/")
**/
;

select parent,count() from /matrix/ldap group by parent having count()>1
/**
output()
**/
;

select otype,grpset,count(id) from /matrix/ldap group by otype, grpset
/**
output()
**/
;

select otype,count(id) from /matrix/ldap group by otype, grpset
/**
output()
**/
;

select grpset,count(lft) as countlftnotnull,count(*) as countall from /matrix/ldap group by otype, grpset
/**
output()
**/
;

select otype,grpset,max(lft),min(lft),sum(lft),avg(lft),count(lft) as CountNotNullLft,count(*) as CountAll from /matrix/ldap group by otype, grpset
/**
output()
**/
;