I have a table (2016 New) like that with some duplicates

ID  equipmemt serial number 
1   1         111
2   2         121
3   3         731
4   1         222
5   1         012
6   2         728

I would have a table whit each equipment but only with the greater serial number like

ID  equipmemt serial number 
1   4         222
6   2         728
3   3         731

I try to aggregate a with:

SELECT 
 [2016 New].ID,  
 Max([2016 New].[Numero di serie]) AS [MaxOfNumero di serie],  
 [2016 New].Equipment, 
FROM [2016 New]
GROUP BY [2016 New].ID,[2016 New].Equipment;

But it doesn’t work
Do you have any suggestion?

Thank you