蛋疼的 查询,

explain select * from IMUser as u,(select *from IMMessage order by IMMessage.sendData desc) as m where (m.messageSenderId = u.openfireAccountId or m.messageReceiverId = u.openfireAccountId) and (u.openfireAccountId != 1234) group by u.openfireAccountId  

posted @   路在脚下,  阅读(132)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示