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

9 votes128 views4 answers
Postgresql export database
SQL
0 vote116 views1 answer
Json not contains mysql
SQL
3 votes116 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote124 views1 answer
DATEDIFF minute postgres
SQL
0 vote107 views1 answer
Postgres set default schema
SQL
0 vote110 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote118 views1 answer
Do postgresql
SQL
0 vote116 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote75 views1 answer
Flask_sqlalchemy install
SQL
0 vote119 views1 answer
Get create sql of hibernqte entity
SQL