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

0 vote323 views1 answer
How to convert DateTime to VarChar SQL
SQL
1 vote336 views1 answer
How to start with sql
SQL
5 votes320 views1 answer
How to use rank function in sql
SQL
1 vote314 views1 answer
Show table columns
SQL
0 vote330 views1 answer
Order by in codeigniter query builder
SQL
3 votes313 views2 answers
How to View column names of a table in SQL
SQL
1 vote301 views1 answer
Mysql select row with max value group by
SQL
0 vote358 views1 answer
Acutal month year
SQL
0 vote322 views2 answers
How to check if sqlite table exists in nodejs
SQL
15 votes336 views5 answers
Show tables in oracle
SQL