如果你有 message_id 作为唯一标识符,则可以使用 group by ``` WITH ABC AS (SELECT MAX(order_index) AS order_index,message_id FROM MESSAGES GROUP BY message_id) SELECT MESSAGE FROM MESSAGES INNER JOIN ABC ON ABC.message_id = MESSAGES.message_id AND ABC.order_index= MESSAGES.order_index;
1条答案
按热度按时间disho6za1#
如果你有
message_id
作为唯一标识符,则可以使用group by
```WITH ABC AS (SELECT MAX(order_index) AS order_index,message_id FROM MESSAGES GROUP BY message_id)
SELECT MESSAGE FROM MESSAGES
INNER JOIN
ABC
ON ABC.message_id = MESSAGES.message_id
AND ABC.order_index= MESSAGES.order_index;