Select rows with column with min value

Viewed 10088

I need to select the rows with the minimum distance by grouping on the OrganisationID. Here is my data in a single table:

ID  OrganisationID    Distance
0        10             100
1        10             200
3        10             50
4        20             80
5        20             300

This is the result I want:

ID  OrganisationID    Distance
3        10             50
4        20             80
2 Answers
Related