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 vote181 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote234 views1 answer
SQL Query to delete all the tables in a database
SQL
1 vote242 views1 answer
Hackerrank sql test solutions
SQL
0 vote220 views1 answer
Varchar format not case sensitive sql
SQL
0 vote205 views1 answer
WHERE not regex in SQL
SQL
0 vote214 views1 answer
Command line mysql xampp
SQL
0 vote204 views1 answer
Drop column from table if exist on live server mysql
SQL
2 votes257 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote203 views1 answer
Sql query contains multiple ids
SQL
0 vote241 views1 answer
Stored function in sql
SQL