Mysql find max value row

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

Mysql find max value row

SELECT t1.*
FROM employees t1
INNER JOIN (
    SELECT id, max(salary) AS salary FROM employees GROUP BY id
) t2 ON t1.id = t2.id AND t1.salary = t2.salary;

Similar codes

7 votes189 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote204 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote212 views1 answer
Mysql persistence.xml
SQL
1 vote209 views1 answer
Where database run
SQL
-2 votes197 views1 answer
Modify column name in tsql
SQL
0 vote207 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote215 views1 answer
Ubuntu stop mysql from starting on boot
SQL
2 votes210 views2 answers
How to DROP a table in mysql
SQL
0 vote205 views1 answer
Oracle array
SQL
0 vote237 views2 answers
Suse Linux restart MySQL
SQL