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

Similar codes

0 vote341 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
1 vote301 views1 answer
How to select random rows from table
SQL
1 vote312 views2 answers
Limit sqlserver
SQL
5 votes295 views6 answers
Sql add days to date
SQL
0 vote351 views1 answer
SQL server datetime compare
SQL
2 votes368 views1 answer
Sql compare strings
SQL
-1 vote296 views1 answer
How to use update trigger in sql
SQL
2 votes341 views3 answers
How do I add a user to a postgres database? cli
SQL
0 vote294 views1 answer
What are the aggregate function in sql
SQL
3 votes328 views1 answer
Oracle list user grants
SQL