统计计录

各位大虾，有表zhibu有字段xm、shfzh、zhh三个字段，其中字段zhh有很多不同的重复计录，想要的结果是：所有计录都显示,重复的计录全部显示在前面.请大虾们帮帮忙，先谢谢!!

这样?
SQL code

select * from zhibu as a  order by (select count(*) from zhidu where zhh=a.zhh) desc,zhh

SQL code

select
  a.*
from
  zhibu a,
  (select zch,count(1) as num from zhibu group by zch)b
where
  a.zhh=b.zhh
order by
  b.num desc,a.zhh

如果是先按照zhh的多少来降序,然后按照shfzh升序.
可参考如下:

SQL code

select a.* from zhibu a 
order by (select count(1) from zhibu b where b.zhh = a.zhh) desc , a.zhfzh

上面写错一个字段名称.

SQL code

select a.* from zhibu a 
order by (select count(1) from zhibu b where b.zhh = a.zhh) desc , a.shfzh