统计计录

[ysycysyc]

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

[中国风]

这样?

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

[--小F--]

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

[dawugui]

[Quote=引用楼主 ysycysyc 的回复:]
各位大虾，有表zhibu有字段xm、shfzh、zhh三个字段，其中字段zhh有很多不同的重复计录，想要的结果是：所有计录都显示,重复的计录全部显示在前面.请大虾们帮帮忙，先谢谢!!
[/Quote]如果是先按照zhh的多少来降序,然后按照shfzh升序.
可参考如下:

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

[dawugui]

上面写错一个字段名称.

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