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 vote132 views1 answer
Get first name and last name from full name string in SQL
SQL
9 votes181 views1 answer
No sql
SQL
1 vote130 views4 answers
Between vs in sql
SQL
9 votes154 views3 answers
Import DB through mysql console
SQL
29 votes134 views6 answers
Delete all rows from table mysql
SQL
0 vote135 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
-1 vote191 views5 answers
Left join
SQL
0 vote143 views1 answer
Select amount weeks between two dates mysql
SQL
0 vote150 views1 answer
Sql update subtract value
SQL
41 votes213 views6 answers
Alter table add column in SQL Server
SQL