Delete Records from a Table Based on Count and Latest Record

Fixing Delete Statements: A Solution to Remove All Rows Except One per Partition