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

53 votes314 views6 answers
How to install mysql ubuntu
SQL
0 vote122 views1 answer
Restart sql server command line linux
SQL
0 vote180 views1 answer
Postgres dump sql insert
SQL
1 vote148 views1 answer
Check current sequence value postgres
SQL
0 vote157 views1 answer
Plpgsql create function
SQL
0 vote134 views1 answer
Sql reverse order of results
SQL
0 vote122 views1 answer
How to get data between a last week in mysql
SQL
0 vote130 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote143 views1 answer
Docker open terminal mysql server
SQL
0 vote126 views1 answer
Sql change primary key to composite key
SQL