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

0 vote117 views2 answers
Sql last updated
SQL
0 vote134 views1 answer
Insert into select with group by
SQL
0 vote143 views1 answer
Sqlite version check
SQL
50 votes217 views6 answers
Install mysql on ubuntu
SQL
0 vote134 views1 answer
Ver usuarios mysql
SQL
1 vote197 views1 answer
Truncate table in postgresql and reset id
SQL
4 votes126 views1 answer
Oracle delete last row
SQL
2 votes85 views4 answers
Mysql change database character set to utf8mb4
SQL
2 votes77 views1 answer
Mysql admin u root p password change password
SQL
1 vote112 views1 answer
Oracle finding duplicate records
SQL