Can you please be more detailed on the relationship within the table. This type of ordering is usually easily accomplished with a simple group and partition by but the details are not jumping out at us. It almost seems like there is a missing key for the relationship unless your results are just varying all over.