0

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?

Larnu
  • 76,706
  • 10
  • 34
  • 63

0 Answers0