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 vote226 views3 answers
Psql fatal database does not exist
SQL
0 vote274 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote433 views1 answer
Sql datum formatieren
SQL
0 vote232 views1 answer
How to get parent and child record in single query using sql
SQL
1 vote227 views1 answer
How not to sort by average rating
SQL
1 vote214 views1 answer
Snowflake rename column name
SQL
25 votes250 views5 answers
Mysql replace text
SQL
1 vote199 views1 answer
Mamp mysql path mac
SQL
2 votes202 views1 answer
Sql update alias
SQL
0 vote198 views1 answer
Order by ip address sql
SQL