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

17 votes217 views1 answer
Selecting name that contain certain word in sql
SQL
4 votes182 views1 answer
Psql get sequences
SQL
17 votes184 views6 answers
Current date in sql
SQL
0 vote189 views1 answer
Insert array into mysql column
SQL
1 vote205 views2 answers
Oracle leftmost characters
SQL
0 vote202 views1 answer
Mysqli last row
SQL
0 vote184 views4 answers
Postgresql between month
SQL
0 vote185 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
-1 vote243 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote190 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL