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 vote359 views1 answer
Get yesterday date ISO in psql
SQL
0 vote368 views1 answer
Sql get date from timestamp
SQL
6 votes361 views1 answer
Oracle list primary key
SQL
0 vote368 views1 answer
Select row with latest date mysql
SQL
1 vote406 views1 answer
Concat first name and last name in mysql
SQL
0 vote448 views1 answer
Scheduled mysql database backup in linux
SQL
1 vote364 views1 answer
Mysql view command
SQL
3 votes354 views1 answer
Oracle revoke
SQL
0 vote366 views1 answer
Mysql export search results
SQL
0 vote342 views1 answer
Psql no such file or directory
SQL