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 vote219 views1 answer
Mysql change timestamp on update
SQL
0 vote195 views1 answer
Cast as decimal postgresql
SQL
0 vote203 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
3 votes266 views1 answer
Apex call duration
SQL
0 vote195 views1 answer
Backup a table in sql
SQL
0 vote366 views1 answer
The differnece between to values in sql
SQL
9 votes211 views2 answers
Sql limit order by
SQL
1 vote211 views2 answers
Sql multiline comment
SQL
1 vote193 views1 answer
Can we drop a primary key
SQL
0 vote256 views1 answer
Oracle temporary table
SQL