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

24 votes193 views5 answers
List mysql users
SQL
10 votes191 views4 answers
Primary key in sql
SQL
3 votes166 views1 answer
Insert into table from another table mysql
SQL
1 vote184 views1 answer
How to select rows with no matching entry in another table?
SQL
20 votes200 views3 answers
How to open postgresql in mac
SQL
5 votes175 views1 answer
Oracle asynchronous query
SQL
7 votes169 views1 answer
Grant schema permissions postgres
SQL
8 votes183 views1 answer
Oracle search code in packages
SQL
1 vote168 views1 answer
Funzioni plsql
SQL
0 vote176 views1 answer
Date diff sql
SQL