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

9 votes307 views2 answers
SELECT User,Host FROM mysql.user;
SQL
1 vote293 views1 answer
Oracle create as select
SQL
0 vote285 views1 answer
Prepared statement mysql java delete selected rows
SQL
18 votes282 views3 answers
Mysql number format
SQL
0 vote252 views1 answer
Get only first row mysql
SQL
0 vote284 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
1 vote303 views1 answer
Age postgres
SQL
0 vote286 views1 answer
Update view sql
SQL
0 vote275 views1 answer
Create table if not exist with exceptions
SQL
0 vote300 views1 answer
Sql query contains multiple ids
SQL