select th yuefen as月份 th guifang as联系人 th fangshi as主被 Hy, sum(th shichang) from tonghua where th fangshi=E HL' and th yuefen=5 group by th duifang order by sum(th shichang )desc limit 5, select th yuefen as月份 th duif ang as联系人 th fangshi as主被 叫sum( h shichang) from tonghua where th fangsh主叫 and th yuefen=6 group by th duifang order by sum(th shichang) desc limit 5 select th yuefen as月份 th guifang as联系人 th fangshi as主被 叫, sum(th shichang) from tonghua where th fangshi被叫 and th yuefen=1 group by th duifang order by sum( th shichang) desc limit 5 select th yuefen as月份 th guifang as联系人 th fangshi as主被 Hy, sum(th shichang)from tonghua where th fangshi= Hy,' and th yuefen=2 group by th duifang order by sum(th shichang) desc limit 5; select th yuefen as月份 th guifang as联系人 th fangshi as主被 ng) from tonghua where th fangshi=#Ay' and th yuefen=3 group by th duifang order by sum(th shichang) desc limit 5 select th yuefen as月份 th guifang as联系人 th fangshi as主被 叫,sum( h shichang) from tonghua where th fangshi被叫 and th yuefen=4 group by th duifang order by sum(th shichang) desc limit 5 select th yuefen as月份 th guifang as联系人 th fangshi as主被 叫,sum( h shichang) from tonghua where th fangshi被叫 and th yuefen=5 group by th duifang order by sum(th shichang) desc limit 5; select th yuefen as月份 th huifang as联系人 th fangshi as主被 叫, sum(th shichang) from tonghua where th fangshi被唧 and th yuefen=6 group by th duifang order by sum(th shichang) desc limit 5; 结 果 月份联系人 主被叫sum(t_ shichang 主叫 主叫 13673697112 主 18614980813 主叫11 select th_yuefen as 月 份 ,th_duifang as 联系人 ,th_fangshi as 主 被 叫,sum(th_shichang) from tonghua where th_fangshi='主叫' and th_yuefen=5 group by th_duifang order by sum(th_shichang) desc limit 5; select th_yuefen as 月 份 ,th_duifang as 联系人 ,th_fangshi as 主 被 叫,sum(th_shichang) from tonghua where th_fangshi='主叫' and th_yuefen=6 group by th_duifang order by sum(th_shichang) desc limit 5; select th_yuefen as 月 份 ,th_duifang as 联系人 ,th_fangshi as 主 被 叫,sum(th_shichang) from tonghua where th_fangshi='被叫' and th_yuefen=1 group by th_duifang order by sum(th_shichang) desc limit 5; select th_yuefen as 月 份 ,th_duifang as 联系人 ,th_fangshi as 主 被 叫,sum(th_shichang) from tonghua where th_fangshi='被叫' and th_yuefen=2 group by th_duifang order by sum(th_shichang) desc limit 5; select th_yuefen as 月 份 ,th_duifang as 联系人 ,th_fangshi as 主 被 叫,sum(th_shichang) from tonghua where th_fangshi='被叫' and th_yuefen=3 group by th_duifang order by sum(th_shichang) desc limit 5; select th_yuefen as 月 份 ,th_duifang as 联系人 ,th_fangshi as 主 被 叫,sum(th_shichang) from tonghua where th_fangshi='被叫' and th_yuefen=4 group by th_duifang order by sum(th_shichang) desc limit 5; select th_yuefen as 月 份 ,th_duifang as 联系人 ,th_fangshi as 主 被 叫,sum(th_shichang) from tonghua where th_fangshi='被叫' and th_yuefen=5 group by th_duifang order by sum(th_shichang) desc limit 5; select th_yuefen as 月 份 ,th_duifang as 联系人 ,th_fangshi as 主 被 叫,sum(th_shichang) from tonghua where th_fangshi='被叫' and th_yuefen=6 group by th_duifang order by sum(th_shichang) desc limit 5; 结果：