Maintaining a grouped running MAX (or MIN) SQL Sentry's Aaron Bertrand (@AaronBertrand) shows the most efficient way to return a running MAX or MIN aggregate in a grouped SQL Server query. Aaron Bertrand ◆ October 8, 2015 0