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 vote102 views1 answer
Show specific events on mysql
SQL
0 vote116 views1 answer
Sql query to find percentage of null values in a table
SQL
1 vote117 views1 answer
Oracle create as select
SQL
0 vote105 views1 answer
Mysql uuid
SQL
1 vote106 views1 answer
Mysql show table character set
SQL
1 vote106 views1 answer
Postgres killing connections on db
SQL
3 votes95 views1 answer
Oracle nextval
SQL
0 vote96 views1 answer
Postgresql certain first 4 characters in string
SQL
2 votes109 views4 answers
Check timezone of mysql database
SQL
7 votes113 views1 answer
Oracle pagination query offset
SQL