SQL Server October 8th, 2015 Maintaining a grouped running MAX (or MIN) I show the most efficient way to return a running MAX or MIN aggregate in a grouped SQL Server query.