此解决方案只从您的表中进行一次选择,因此速度更快。根据sqlfiddle.com上的测试,它只适用于mysql和sqlite(用于sqlite remove desc)。也许它可以被调整到我不熟悉的其他语言上。
SELECT *
FROM ( SELECT *
FROM ( SELECT 1 as id, 1 as rev, 'content1' as content
UNION
SELECT 2, 1, 'content2'
UNION
SELECT 1, 2, 'content3'
UNION
SELECT 1, 3, 'content4'
) as YourTable
ORDER BY id, rev DESC
) as YourTable
GROUP BY id