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

Similar codes

0 vote319 views1 answer
Create boolean column in MySQL with false as default value?
SQL
0 vote337 views1 answer
Write SQL in ruby on rails
SQL
12 votes312 views4 answers
Mysql ifnull
SQL
0 vote310 views2 answers
How do I install microsoft SQL on my Mac?
SQL
0 vote304 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
3 votes316 views1 answer
How to find names includes in sql
SQL
0 vote328 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
2 votes320 views1 answer
Oracle generated column
SQL
0 vote355 views1 answer
Postgresql alter table sequence
SQL
103 votes513 views1 answer
Like sql
SQL