Say I have a database like this
section version
1 1
1.1 2
1.2 3
1.1 4
And I want to the SELECT to return this
section version
1 1
1.2 3
1.1 4
I want each "section" only once, if a "section" appears twice I want the "section"
with the largest "version".
How can I do this?