[统计]统计的时候能排序么？(在线等待，答对给分)

[PI_2002]

统计语句如下：

select t_main.zby,count(t_main.zby) as cjsl
from t_main
where t_main.zby in (select t_man.xm from t_man where t_man.lvl > 1) and (t_main.jjsj between @m_ssj and @m_esj)
group by t_main.zby

我想将统计出来的数据按降序排列，怎么处理

[iamxia]

加上
order by cjsl desc

[icevi]

加order by count(t_main.zby) ，是想要这样的吗？