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 vote181 views1 answer
Mysql search like order by best match
SQL
6 votes158 views1 answer
Postgres get size of database
SQL
0 vote194 views1 answer
Plpgsql create function
SQL
0 vote152 views1 answer
Get all employees if name ends with in sql
SQL
0 vote161 views1 answer
Pagination with row_number
SQL
0 vote186 views2 answers
Wordpress change url after migration mysql query
SQL
14 votes165 views3 answers
Oracle sql limit results
SQL
8 votes149 views5 answers
Alter table add column with default value
SQL
0 vote160 views1 answer
Sql grant select only
SQL
0 vote152 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL