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 vote182 views1 answer
Console output pl sql
SQL
5 votes201 views1 answer
Sql integer to serial
SQL
0 vote188 views1 answer
Select password from user mysql
SQL
0 vote186 views1 answer
Mysql Install Ubuntu with native password
SQL
-1 vote302 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote198 views1 answer
Soql user profile
SQL
1 vote247 views1 answer
Is sql fast
SQL
0 vote260 views1 answer
Regex mongoose
SQL
3 votes196 views5 answers
Sql select
SQL
1 vote186 views1 answer
Moodle query item quiz
SQL