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

2 votes397 views3 answers
Sql delete duplicate
SQL
0 vote332 views1 answer
Mysql case when null
SQL
1 vote332 views1 answer
Postgresql delete cascade
SQL
2 votes369 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote347 views3 answers
How to run sql query
SQL
3 votes381 views1 answer
Oracle undo tablespace schema
SQL
2 votes309 views3 answers
Application.properties spring boot mysql
SQL
0 vote358 views1 answer
How to map sql column to custom names
SQL
0 vote307 views1 answer
Zsh: command not found: mysql mamp
SQL
0 vote343 views1 answer
Oracle table free space
SQL