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 vote114 views1 answer
Double in sql server example
SQL
0 vote119 views1 answer
Get role postgres
SQL
4 votes201 views1 answer
What are the data types
SQL
0 vote76 views1 answer
Sql select rows with simlar names
SQL
3 votes110 views1 answer
APEX elapsed time
SQL
0 vote172 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote117 views1 answer
Inserted row count tsql
SQL
-1 vote114 views1 answer
Sql oracle take only last results
SQL
0 vote115 views1 answer
Sql join on a subquery
SQL
49 votes190 views6 answers
Get duplicate records in sql
SQL