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

17 votes119 views6 answers
Get last record in sql
SQL
0 vote121 views1 answer
Alter table add check constraint oracle
SQL
2 votes110 views2 answers
Sql first character
SQL
0 vote114 views1 answer
Mysql query problems and solutions
SQL
1 vote115 views2 answers
Changes not showing on website server odoo
SQL
3 votes114 views1 answer
Sql cast to integer
SQL
1 vote117 views1 answer
Mysql add fields
SQL
0 vote112 views1 answer
List column names of multiple tables psql
SQL
0 vote71 views1 answer
Oracle sysdba connect as another user
SQL
1 vote110 views1 answer
Mysql find tables with column name
SQL