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

37 votes189 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote173 views1 answer
MySQL import data from large CSV file
SQL
1 vote160 views1 answer
Sql server update column based on another table
SQL
2 votes151 views1 answer
Columns Present in a table
SQL
0 vote178 views1 answer
Last date for each user sql
SQL
11 votes193 views2 answers
Having keyword sql
SQL
0 vote144 views1 answer
Power query case when
SQL
0 vote139 views1 answer
Check if a word appears at the end sql query
SQL
15 votes139 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote150 views1 answer
Hive batch drop table
SQL