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

1 vote238 views1 answer
Python clean sql string
SQL
2 votes231 views1 answer
Oracle sql concatenate results into string
SQL
0 vote258 views1 answer
Shrink database file in sql server
SQL
0 vote249 views1 answer
Acutal month year
SQL
0 vote224 views1 answer
Oracle last character of string
SQL
7 votes261 views6 answers
Mysql group concat
SQL
1 vote239 views1 answer
Mysql month name extract
SQL
0 vote237 views1 answer
Mysql make date from 2 column
SQL
0 vote245 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote229 views1 answer
No suitable driver found for sqlite
SQL