select * from WXDA_GROUP_MESSAGE where id = '3385762713863199347' 把这条消息的前20条和后20条的sql写出来
时间: 2024-02-11 19:04:47 浏览: 22
前20条消息的SQL语句:
```
SELECT * FROM WXDA_GROUP_MESSAGE WHERE group_id = (SELECT group_id FROM WXDA_GROUP_MESSAGE WHERE id = '3385762713863199347') AND id < '3385762713863199347' ORDER BY id DESC LIMIT 20
```
后20条消息的SQL语句:
```
SELECT * FROM WXDA_GROUP_MESSAGE WHERE group_id = (SELECT group_id FROM WXDA_GROUP_MESSAGE WHERE id = '3385762713863199347') AND id > '3385762713863199347' ORDER BY id ASC LIMIT 20
```
这两条SQL语句分别查询了与指定消息在同一群聊中的前20条和后20条消息。其中,先通过指定消息的ID,查询出该消息所在的群聊ID,然后再根据该群聊ID和指定消息的ID,分别查询前20条和后20条消息。前20条消息按照ID降序排列,后20条消息按照ID升序排列。