I am trying to find out for each order which was the last date that particular order had. Also there is more than one order and each have multiple orders against them.
<tbody>
ID
Sched.StartDate
Order
5206
05/01/2010
11175203
5206
03/01/2012
13627997
5206
31/12/2013
5206...