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 vote191 views1 answer
Oracle simple quote
SQL
0 vote246 views1 answer
Generate random & unique mysql string
SQL
1 vote203 views1 answer
Sqlite update from another table
SQL
0 vote208 views1 answer
Second Step in installing SQL workbench
SQL
3 votes178 views1 answer
Oracle rollback
SQL
25 votes211 views1 answer
How to update an attribute in MySQL
SQL
0 vote206 views1 answer
How to alter length character varying postgres
SQL
0 vote179 views1 answer
Sql trim whitespace
SQL
1 vote189 views1 answer
Postgres concat_ws
SQL
0 vote172 views2 answers
Delete query sql server
SQL