I am trying to get the student name that has the lowest mark in each class.
Class Student Mark
A Pablo 2
A Jorge 4
A Albaro 7
B Jose 2
B Pedro 5
B Mikel 9
C Niko 8
C Alberto 6
C Joe 9
And I want to get.
Class Student Mark
A Pablo 2
B Jose 2
C Alberto 6
In each class, the marks cannot be repeated.
Are there any way to do it?