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 vote107 views1 answer
Implicit inner join table alias
SQL
0 vote100 views1 answer
How to make case insensitive in sql
SQL
1 vote105 views1 answer
Sql server datetime vs datetime2
SQL
2 votes162 views1 answer
Mysql create user with remote access
SQL
0 vote99 views1 answer
Where case insensitive like mysql
SQL
1 vote111 views1 answer
Import sql file mysql commadn line
SQL
0 vote136 views1 answer
Mysql collation portugues brasil
SQL
3 votes97 views3 answers
Print in pl sql
SQL
3 votes102 views2 answers
Oracle grants
SQL
0 vote105 views1 answer
Oracle list datafiles
SQL