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

8 votes123 views5 answers
Grant permission in postgres
SQL
7 votes121 views3 answers
How to check table name in current database sql
SQL
1 vote126 views1 answer
Psql datetime grather than
SQL
0 vote120 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote128 views1 answer
Python sql last insertend
SQL
5 votes85 views1 answer
Postgres upsert
SQL
0 vote125 views1 answer
SQL loop with cursor
SQL
0 vote124 views1 answer
Hibernate dialect property xml for mysql 8
SQL
1 vote138 views1 answer
Join to find results not in another table
SQL
0 vote132 views1 answer
Mysql events not work
SQL