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 vote179 views1 answer
Alter table fulltext
SQL
0 vote196 views1 answer
Database db connection string format
SQL
0 vote183 views1 answer
How to fetch unique records from two tables
SQL
0 vote195 views1 answer
New rails app with mysql
SQL
0 vote194 views1 answer
Datatables server side filter where clause
SQL
10 votes195 views2 answers
Oracle alter sequence nextval
SQL
0 vote171 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote186 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote173 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote160 views2 answers
Avg() sql
SQL