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 votes239 views2 answers
Insert all in sql
SQL
0 vote234 views1 answer
Sql comparison operators
SQL
1 vote245 views1 answer
Sample in sql
SQL
0 vote249 views3 answers
Convert sql query to python pandas
SQL
3 votes252 views1 answer
Postgres update column with value from another table
SQL
0 vote257 views1 answer
Insert array into mysql column
SQL
-1 vote244 views2 answers
Full join sql
SQL
0 vote269 views1 answer
Mariadb create index if not exists
SQL
0 vote248 views1 answer
Mysqlimport
SQL
2 votes265 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL