摘要:
mysql 8WITH ranked_messages AS ( SELECT m.*, ROW_NUMBER() OVER (PARTITION BY name ORDER BY id DESC) AS rn FROM messages AS m)SELECT * FROM ranked_mess 阅读全文
posted @ 2022-06-28 15:17 且行且思 阅读(1276) 评论(0) 推荐(0)
|
|||
|
摘要:
mysql 8WITH ranked_messages AS ( SELECT m.*, ROW_NUMBER() OVER (PARTITION BY name ORDER BY id DESC) AS rn FROM messages AS m)SELECT * FROM ranked_mess 阅读全文
posted @ 2022-06-28 15:17 且行且思 阅读(1276) 评论(0) 推荐(0) |
|||