如何在单个表中获取每组键值的最大行？

I have an MSSQL 2000 table that has a lot of duplicate entries. Each row has an EffectiveChange data column. I want to get the most up to date row by getting the row with the max(EffectiveChange) for each key value. I have an MSSQL 2000 table that has a lot of du