摘要：
select zhongjie,num,ROW_NUMBER()over(order by num desc) as rn from ( select zhongjie,count(zhongjie) as num from table1 where signdate>='2013-2-1 0:00:00' and signdate<='2013-2-28 23:59:59' group by zhongjie )as t1 where zhongjie<>'www' order by num desc 阅读全文
