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 vote176 views1 answer
Ms sql filter all sympbol
SQL
1 vote161 views1 answer
Oracle rolling back
SQL
0 vote200 views1 answer
Oracle plsql sleep
SQL
7 votes224 views3 answers
Sql server check if temp table exists
SQL
0 vote173 views1 answer
Oracle create table auto generated primary key
SQL
0 vote166 views1 answer
Mysql delete from where like
SQL
3 votes171 views1 answer
How to find names includes in sql
SQL
0 vote124 views1 answer
Sql select rows with simlar names
SQL
7 votes182 views1 answer
Query postgres delete duplicates
SQL
0 vote184 views1 answer
Fetching data from mysqldb
SQL