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 vote291 views1 answer
Oracle undo usage per session
SQL
-1 vote289 views5 answers
Operator in sql
SQL
1 vote282 views2 answers
Sql now - 1 day
SQL
0 vote275 views1 answer
Assign value to var in SQL
SQL
18 votes278 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote224 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote288 views1 answer
Every Derived yable must have its own alias
SQL
5 votes281 views3 answers
Oracle list columns in schema
SQL
1 vote299 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote292 views1 answer
How to import pymysql through jupyter notebook for windows
SQL