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 vote114 views1 answer
Mysql reset wp_options
SQL
0 vote108 views4 answers
Mysql replace regex
SQL
4 votes113 views1 answer
Oracle show errors
SQL
10 votes125 views2 answers
Select nextval from sequence oracle
SQL
0 vote132 views2 answers
Nested query
SQL
1 vote114 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote112 views1 answer
Sql requete number pair
SQL
-1 vote106 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote109 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote73 views1 answer
Sql table to store status
SQL