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 vote162 views1 answer
Oracle sql log to console
SQL
3 votes173 views1 answer
Oracle user privileges
SQL
1 vote157 views1 answer
How refresh navicat tables to see new tables
SQL
1 vote348 views3 answers
Create table from existing table in sql
SQL
5 votes157 views2 answers
Sql conn
SQL
2 votes156 views1 answer
Mysql auto increment jumping
SQL
4 votes189 views2 answers
Oracle unlock account
SQL
1 vote156 views1 answer
Error code 1055
SQL
6 votes168 views3 answers
Update with inner join postgres
SQL
3 votes135 views1 answer
Postgresql where current year
SQL