Skip to content
Advertisement

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
Advertisement