SQL select only rows with max value on a column
| id | rev | content |
|---|---|---|
| 1 | 3 | The earth is like a ball. |
| 2 | 1 | One hundred angels can dance on the head of a pin |
(4 rows affected)
(2 rows affected)
(2 rows affected)
| id | rev | content |
|---|---|---|
| 1 | 3 | The earth is like a ball. |
| 2 | 1 | One hundred angels can dance on the head of a pin |