Delete from [CurrencyRate] where Not [StartDate] in (Select Max([Startdate]) from [CurrencyRate] Group By Year([StartDate]))