mysql+跨表分组_mysql跨表查询、ORDER BY和GROUP BY、MAX相结合查找出最新一条信息如何做？...

messagetableidsend_idreceiver_id112212323423543653763853我现在的mysql是这样的SELECT*FROMmessagesASmINNERJOINusersASuON(m.receiver_id=u.idANDm.receiver_id='3')WHERE1=1GROU...

message table

id send_id receiver_id

1 1 2

2 1 2

3 2 3

4 2 3

5 4 3

6 5 3

7 6 3

8 5 3

我现在的mysql是这样的

SELECT * FROM messages AS m INNER JOIN users AS u ON (m.receiver_id=u.id AND m.receiver_id='3' ) WHERE 1=1 GROUP BY m.sender_id ORDER BY m.id DESC LIMIT 0,10

实现的结果是查询出来了，但是只查得到

id send_id receiver_id

3 2 3

5 4 3

6 5 3

7 6 3

而我想取的数据应该是最新一条就是

id send_id receiver_id

4 2 3

5 4 3

7 6 3

8 5 3

我查了一些文档，说要加个子句 max一下id就行了,但是我不知道应该如何加。

补充一：

一楼所说的

SELECT * FROM messages AS m INNER JOIN users AS u