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()**/;