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

1 vote266 views1 answer
How to use a trigger to validate input data
SQL
6 votes283 views2 answers
Postgresql restore from dump
SQL
2 votes265 views1 answer
Brew start postgres manual
SQL
0 vote285 views1 answer
Mysql exception output
SQL
1 vote274 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
24 votes258 views4 answers
How to add column sql
SQL
0 vote298 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
1 vote258 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote264 views1 answer
Cast float mysql
SQL
0 vote265 views1 answer
Sql make sure every user is unqiuew
SQL