Skip to content

Get the lowest Score of each distinct Name and distinct Group

Need to get the lowest Score of each distinct Name and distinct Group. Thank you.

Data:
Group   Name    Score
A   N1  1
B   N1  5
C   N1  3
A   N1  4
A   N2  2
A   N3  6
A   N1  8
B   N1  7
B   N2  9

Result:

A   N1  1
B   N1  5
C   N1  3
A   N2  2
A   N3  6
B   N2  9

Advertisement

Answer

 select [Group],   Name ,  min( Score)
 from my_table
 group by [Group], Name
User contributions licensed under: CC BY-SA
6 People found this is helpful