MYSQL查询数据中通讯最多的两个人

SELECT GREATEST( sender_id, recipient_id ) , LEAST( sender_id, recipient_id ) , COUNT( * ) AS a
FROM `pmsg`
GROUP BY CONCAT( GREATEST( sender_id, recipient_id ) , LEAST( sender_id, recipient_id ) )
ORDER BY a DESC
LIMIT 3

注：sender_id：是指发件人id，recipient_id是指收件人id

http://www.ink520.com/
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/myphper/p/3227058.html