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 vote345 views1 answer
Oracle grant on all tables in schema
SQL
15 votes382 views3 answers
Mysql update add to existing value
SQL
0 vote325 views1 answer
Call procedure in wordpress
SQL
0 vote345 views1 answer
Code to move ietms from one table to another myswl
SQL
3 votes337 views2 answers
Find string in stored procedure sql server
SQL
0 vote339 views1 answer
Sql server remove enter from string
SQL
0 vote323 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote344 views1 answer
DATEDIFF minute postgres
SQL
0 vote418 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote290 views8 answers
Convert sql query to linq online
SQL