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

3 votes167 views1 answer
How to uninstall microsoft sql server
SQL
-2 votes151 views2 answers
Union vs union all in sql
SQL
6 votes188 views1 answer
Check Table Exists
SQL
0 vote144 views1 answer
Drop specific row postgresql
SQL
0 vote155 views1 answer
Primary key multiple
SQL
2 votes141 views1 answer
Sql column values comma separated
SQL
0 vote152 views2 answers
How covert into int in maria db
SQL
0 vote240 views1 answer
Mysql select field if condition
SQL
6 votes172 views6 answers
Rename column postgres
SQL
0 vote112 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL