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

0 vote147 views1 answer
Components/Fields of Internal Table
SQL
2 votes138 views1 answer
Update with join sql server
SQL
0 vote135 views1 answer
Mysql percentage of total
SQL
4 votes151 views1 answer
Oracle show errors
SQL
0 vote173 views1 answer
Carbon mysql d m y to y-m-d
SQL
13 votes159 views2 answers
Sql join 3 tables
SQL
3 votes149 views2 answers
Mysql HAVING
SQL
0 vote161 views1 answer
Update sqlite
SQL
5 votes171 views1 answer
Oracle get ddl
SQL
1 vote163 views2 answers
Logical operators in sql
SQL