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 vote182 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote210 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote385 views1 answer
Redirection 301 htaccess nom de domaine
SQL
8 votes180 views1 answer
Mysql limit rows
SQL
0 vote188 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote183 views1 answer
How to move a column to different spot mysql
SQL
0 vote191 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
8 votes223 views2 answers
Default sql server port
SQL
0 vote157 views1 answer
Sql cross apply vs join
SQL
1 vote216 views1 answer
Check if mysql is installed
SQL