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 vote175 views1 answer
Testing sql queries
SQL
0 vote228 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote232 views1 answer
Mysql check if lowercase
SQL
7 votes231 views3 answers
Select latest entry in sql table
SQL
34 votes226 views6 answers
Sql change data type
SQL
0 vote210 views1 answer
Sql view index
SQL
1 vote221 views2 answers
Sql select only first occurrence
SQL
1 vote259 views1 answer
Liquibase alter column type / length
SQL
0 vote229 views1 answer
PSQL qith variables
SQL
-1 vote189 views1 answer
How to create script to connect to oracle database and run query
SQL