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

2 votes135 views1 answer
Get first 3 letters name in sql
SQL
2 votes130 views1 answer
Sql to char function with date
SQL
3 votes136 views2 answers
Laravel tosql with bindings
SQL
1 vote153 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
4 votes151 views3 answers
Employee name starting with in sql
SQL
0 vote136 views1 answer
Remove default constraint sql server
SQL
0 vote176 views1 answer
Start stop mysql linux
SQL
2 votes140 views1 answer
Sql column values comma separated
SQL
0 vote166 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
1 vote133 views1 answer
T-sql find object by name
SQL