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 vote119 views1 answer
Sql count null values in all columns
SQL
0 vote119 views3 answers
Fetlife
SQL
0 vote124 views1 answer
Hibernate with springboot mysql
SQL
2 votes120 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
6 votes74 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote193 views1 answer
Sql database size
SQL
0 vote127 views1 answer
Drop unique
SQL
1 vote116 views1 answer
Sql pick random row
SQL
10 votes120 views5 answers
Between keyword in sql
SQL
0 vote114 views1 answer
Postgres copy command
SQL