> > SELECT LH.*, Derived.RecordCount > FROM LocationHistory LH > INNER JOIN (SELECT MAX(Sequence) AS Sequence, count(*) as RecordCount, PartID, SerialNo > FROM LocationHistory > GROUP BY PartID, SerialNo ) Derived > ON LH.Sequence = Derived.Sequence and > LH.PartID = Derived.PartID and > LH.SerialNo = Derived.SerialNo >>