How to get posts with maximum revision?

Question

SQL

Table structure
id int
departmentId int
type int
revision int
How to get records with maximum revision?
i.e. grouped by fields id, departmentId, type

Answer 1

https://stackoverflow.com/questions/39885926/select...

Answer 2

It is generally useless to group by the id field, because it is unique for each record. If without it, then like this:
SELECT departmentId, type, MAX(revision) from table_name GROUP BY departmentId, type

Answer 3

How to get posts with maximum revision?

Literally, the answer was already recently: link the result to the table itself .