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 vote192 views1 answer
Create view in mysql workbench
SQL
0 vote167 views1 answer
Mysql change innodb to myisam
SQL
0 vote156 views1 answer
Dump only data
SQL
1 vote178 views1 answer
Oracle compile schema
SQL
2 votes159 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote156 views1 answer
Mysql cli output to a file
SQL
-1 vote110 views1 answer
Oracle db list usernames
SQL
0 vote140 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote152 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote176 views1 answer
Sql server python connection
SQL