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 vote278 views1 answer
Linebreak sql
SQL
0 vote280 views1 answer
Str_to_date sql server
SQL
0 vote282 views1 answer
Get sum sqlite android
SQL
0 vote277 views1 answer
How change the field place in mysql
SQL
0 vote268 views1 answer
Sqlite3 pragma foreign keys
SQL
-1 vote270 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
4 votes264 views2 answers
Sql vs mysql
SQL
1 vote277 views3 answers
Mysql connection string
SQL
1 vote277 views1 answer
Select count distinct multiple columns sql server
SQL
1 vote287 views1 answer
Mysql select and count left join
SQL