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 vote231 views1 answer
Selecting from a view SQL
SQL
11 votes265 views1 answer
Oracle insert from select
SQL
5 votes202 views1 answer
AND OR NOT operators sql
SQL
0 vote205 views1 answer
Oracle step procedure
SQL
0 vote166 views1 answer
Postrgres trunc
SQL
12 votes182 views1 answer
Docker mysql random root password
SQL
20 votes191 views6 answers
Mysql reset auto increment
SQL
56 votes580 views5 answers
Psql create user
SQL
0 vote196 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote185 views1 answer
Oracle search in date columns
SQL