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

1 vote232 views1 answer
Postgresql create table with timestamp
SQL
10 votes233 views4 answers
Sql pagination
SQL
0 vote215 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote234 views1 answer
Mysql 8 error on identified by
SQL
0 vote254 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote242 views1 answer
How to delete duplicate rows in oracle
SQL
11 votes234 views1 answer
Oracle view ddl
SQL
0 vote229 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
2 votes219 views1 answer
Sqlite insert if not exists
SQL
3 votes224 views3 answers
Mysql get table size
SQL