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 vote208 views1 answer
C# datetime to sql server datetime
SQL
1 vote222 views1 answer
Create new table in SQL from old table with data
SQL
7 votes238 views1 answer
Query postgres delete duplicates
SQL
0 vote174 views1 answer
Import csv to mysql
SQL
0 vote228 views1 answer
Sql max of two values
SQL
0 vote230 views1 answer
Oracle sql copy table without data
SQL
0 vote239 views1 answer
Grant privileges of databse to user
SQL
1 vote211 views1 answer
Postgresql datetrunc too slow
SQL
3 votes238 views1 answer
Mysql insert on dupèlicate
SQL
0 vote211 views1 answer
Fix sqlite3 ruby on rails
SQL