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

1 vote244 views1 answer
Store select query result in variable sql server
SQL
2 votes238 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote234 views1 answer
Python sqlalchemy connection show server
SQL
4 votes239 views2 answers
Mysql delete user if exists
SQL
1 vote244 views1 answer
Update foreign key value in mysql
SQL
0 vote226 views1 answer
Interview experience as a call?
SQL
0 vote216 views1 answer
On update current_timestamp jpa
SQL
0 vote256 views1 answer
Wp_query raw sql
SQL
7 votes233 views2 answers
Show size database mysql
SQL
7 votes254 views6 answers
Mysql group concat
SQL