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 vote140 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote142 views1 answer
How to query without duplicate rows in sql
SQL
11 votes129 views1 answer
Oracle view ddl
SQL
6 votes126 views4 answers
Eloquent to sql with bindings
SQL
0 vote139 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote142 views1 answer
Linked server delete openquery
SQL
1 vote141 views2 answers
Oracle list partitioned tables
SQL
0 vote140 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote150 views1 answer
Oracle change password expiration policy
SQL
8 votes134 views2 answers
Update sql server from another table
SQL