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 vote320 views1 answer
Sql recherche nom prenom
SQL
1 vote315 views1 answer
Delete row mssql
SQL
0 vote332 views1 answer
How to update sql server version
SQL
0 vote334 views1 answer
Date on SQL
SQL
0 vote318 views1 answer
PSQL qith variables
SQL
0 vote314 views1 answer
Convert sql server guid to varbinary
SQL
2 votes304 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote289 views1 answer
Connection error in mysql workbench
SQL
0 vote357 views2 answers
How to get max from each department in sql
SQL
0 vote346 views2 answers
Pop sql insert value into
SQL