Group by duplicate ID and take the highest available amount from other columns

[AshwinS2 (Ashwin S)]

Hi @whitestar
Check this

DataTable Group By Sum and Count using Linq

Instead of sum use max function
thanks
a
Ashwin.S