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

16 votes290 views3 answers
Delete row psql
SQL
0 vote291 views1 answer
Alter database name script
SQL
0 vote311 views1 answer
The fetch keyword oracle
SQL
6 votes290 views2 answers
Where clause in sql
SQL
0 vote309 views1 answer
Contraint default SQL
SQL
0 vote322 views1 answer
Postgresql custom order by
SQL
4 votes289 views1 answer
Oracle session date format
SQL
1 vote306 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote272 views1 answer
How to get all values in a table mysql in c#
SQL
27 votes297 views6 answers
Set password mysql
SQL