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

3 votes319 views2 answers
Postgres inner join vs join
SQL
1 vote322 views1 answer
Oracle sql pad left zeros
SQL
0 vote361 views1 answer
Why do we need data structure in sql
SQL
5 votes274 views1 answer
Mongodb vs
SQL
1 vote331 views1 answer
Table valued functions in sql
SQL
0 vote329 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote328 views1 answer
Nuget sqllite-net-pcl
SQL
0 vote310 views1 answer
Mysql terminal run sql file
SQL
2 votes348 views2 answers
Create temporary table in mysql
SQL
1 vote306 views1 answer
Create new table in SQL from old table with data
SQL