mysql get max value and id
SELECT a.id, a.rev, a.contents FROM YourTable a INNER JOIN ( SELECT id, MAX(rev) rev FROM YourTable GROUP BY id ) b ON a.id = b.id AND a.rev = b.rev
Source: stackoverflow.com
mysql find max value row
SELECT t1.* FROM employees t1 INNER JOIN ( SELECT id, max(salary) AS salary FROM employees GROUP BY id ) t2 ON t1.id = t2.id AND t1.salary = t2.salary;