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

23 votes367 views6 answers
How to create table in sql
SQL
11 votes356 views1 answer
Sql query to find duplicates in column
SQL
0 vote353 views2 answers
Raise notice in postgresql function
SQL
3 votes357 views2 answers
Sqlite print all column names
SQL
0 vote369 views2 answers
Script all indexes in a database
SQL
11 votes786 views4 answers
Reset identity column values in sql server
SQL
2 votes351 views1 answer
Laravel sql String
SQL
0 vote344 views1 answer
Greater than or equal to symbol in postgres
SQL
6 votes352 views2 answers
Psql load dump
SQL
0 vote397 views1 answer
SQL joins in python
SQL