I have a DataTable that has the sample data like this:
ID | HITS | Date 1 | 12 | 1 October 2017 2 | 15 | 1 October 2017 3 | 13 | 1 October 2017 4 | 5 | 1 November 2017 5 | 7 | 1 November 2017 6 | 3 | 1 November 2017
The result that I want is:
ID 2 ==> 15 is the max value for hits in Oct 2017 5 ==> 7 is the max value for hits in Nov 2017
Prefer in VB.NET. We can do this in TSQL BUT since the data is in DataTable already so we have to manipulate at Linq level.