SELECT troubles

wxdqz

New Member
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?
 
Back
Top