odbtools/odbctest/mql/matrix/icbctest/097.mql

select count(distinct model),model FROM
/m3event/entity/node
group by model 
/**
output()
**/
;


select count(distinct model),model FROM
(SELECT 	* FROM 	 /m3event/entity/node) 
group by model 
/**
output()
**/
;



select count(*), aa.model as "中文" from  /m3event/entity/node aa
group by aa.model order by "中文" desc /**output()**/;


select count(*), aa.model as "中文" from (
SELECT 	* FROM 	 /m3event/entity/node) aa 
group by aa.model order by "中文" desc /**output()**/;