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 vote120 views1 answer
Compare field sql server
SQL
1 vote127 views1 answer
Update from table tsql
SQL
0 vote136 views1 answer
Sql select most frequent value in column
SQL
27 votes130 views5 answers
Add column in table
SQL
0 vote131 views1 answer
Char varchar nvarchar sql
SQL
17 votes142 views3 answers
How to change a collumn name in sql
SQL
0 vote126 views1 answer
Distinct data types in a table sql query
SQL
0 vote124 views1 answer
Psql datestyle
SQL
0 vote127 views2 answers
Android sqlite tutorial for beginners
SQL
1 vote132 views1 answer
Oracle apex prevent initial load
SQL