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

1 vote110 views3 answers
Java.sql.sqlexception: access denied for user
SQL
0 vote116 views1 answer
Update having mysql
SQL
2 votes124 views2 answers
Created at and updated at in mysql
SQL
0 vote217 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote130 views1 answer
Get substract count sql
SQL
5 votes121 views1 answer
Postgresql functions
SQL
-1 vote138 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
0 vote121 views1 answer
Mariadb number format
SQL
0 vote121 views2 answers
Postgres default user
SQL
0 vote131 views1 answer
SQL add a totals of differemt rows of the same id
SQL