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

2 votes188 views2 answers
Oracle multiple insert
SQL
5 votes213 views1 answer
Oracle drop index if exists
SQL
0 vote196 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
14 votes204 views4 answers
Remove record from table sql
SQL
0 vote191 views1 answer
Mysql create pool
SQL
1 vote190 views1 answer
Error code 1055
SQL
0 vote204 views1 answer
Oracle table privileges
SQL
0 vote191 views2 answers
Postgresql display subquery as json
SQL
1 vote189 views1 answer
Tsql create unique index composite
SQL
2 votes214 views1 answer
Search query in mysql
SQL