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

27 votes381 views5 answers
Mysql set password for user
SQL
2 votes348 views1 answer
Possgress drop if exists table
SQL
0 vote365 views1 answer
Sql query to find duplicate email address
SQL
1 vote383 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote355 views1 answer
Import big data to mysql
SQL
3 votes424 views2 answers
See mysql users ubuntu
SQL
0 vote354 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
19 votes374 views5 answers
Date between in mysql
SQL
0 vote365 views1 answer
Select amount weeks between two dates mysql
SQL
-1 vote330 views2 answers
How to display top 50 rows?
SQL