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 vote237 views1 answer
Install squirrel sql ubuntu
SQL
0 vote193 views2 answers
Postgres another version
SQL
0 vote203 views1 answer
Postgresql custom order by
SQL
0 vote177 views1 answer
Psql check if value in array
SQL
1 vote193 views1 answer
Mysql take number in string
SQL
3 votes177 views2 answers
Current year sql
SQL
1 vote188 views1 answer
How to select rows with no matching entry in another table?
SQL
2 votes207 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote173 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote191 views1 answer
Restore backup mysql .gz
SQL