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