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 vote268 views1 answer
Create date sql
SQL
0 vote266 views1 answer
Replace content value from old to new sql
SQL
0 vote272 views1 answer
Mysql timediff
SQL
0 vote246 views1 answer
Sql examples from your work
SQL
3 votes274 views1 answer
Select count from table mysql
SQL
0 vote257 views1 answer
Linked server delete openquery
SQL
1 vote253 views1 answer
Create sqlite database in laravel
SQL
1 vote274 views1 answer
Base64 encode sql server
SQL
1 vote265 views3 answers
Reset sql primary key
SQL
0 vote250 views1 answer
Go install mysql
SQL