Sorry lets try the formatting again
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?