Select Max records multiple rows

[eluser]jmadsen[/eluser]

Code:

SELECT articleid, revisionid, revisionnumber
FROM articles
WHERE revisionnumber = (
SELECT max( revisionnumber )
FROM articles a2
WHERE a2.revisionid = articles.revisionid )
GROUP BY revisionid