Need to get the lowest Score of each distinct Name and distinct Group. Thank you.
x
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