ysq1> select dx yuefen as月份, dx guifang as联系人, count( dx xuhao)as短信数 k yuefen=1 group by ifang order by count(dx xuhao) desc 短信数 13633805093 ws in set(0.01 ysq1> select dx yuefen as月份, dx guifang as联系人, count( dx xuhao)as短信数 om duanxin where dx yuefen=2 group by dx dui fang order by count (dx xuhao) desc 短信数 513610518 ysq1> select dx yuefen as月份, dx guifang as联系人, count( dx xuhao)as短信数 duanxin where dx yuefen=3 group by dx duifang order by count (dx xuhao) desc 信数 1367369 rows in set(0.00 sec)16