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 vote215 views3 answers
Mysql on delete set null
SQL
-1 vote212 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
1 vote188 views1 answer
User privileges postgresql information_schema
SQL
0 vote255 views1 answer
Mysql installer no packages found
SQL
0 vote198 views1 answer
Select only one row sql
SQL
0 vote191 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote203 views2 answers
Oracle select
SQL
1 vote196 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote160 views1 answer
Java spring boot connect to sql server
SQL
0 vote182 views2 answers
Get top 1 row of each group
SQL