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 vote345 views1 answer
Mysql wsrep ls
SQL
0 vote365 views1 answer
Sql mod even odd
SQL
18 votes378 views3 answers
Mysql add column default value
SQL
1 vote359 views1 answer
Mysql data from file
SQL
0 vote364 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote359 views1 answer
How to delete python anywhere mysql database
SQL
1 vote378 views1 answer
Connect to mysql database ubuntu
SQL
0 vote412 views1 answer
Mysql delete entire row on condition
SQL
2 votes357 views1 answer
SQL column name Postgre
SQL
0 vote328 views1 answer
Bigquery information_schema schema all columns
SQL