从表中的重复记录中获取最新ID

select R.id,       R.groupid,       R.name,       R.prefrom (select id,   groupid,   name,   pre,  row_number() over(partition by name, pre order by groupid desc) as rn      from RawTable ) as Rwhere R.rn = 1

或者，如果您没有row_number（）

select R1.id,       R1.groupid,       R1.name,       R1.prefrom RawTable as R1  inner join (     select name, pre, max(groupid) as groupid   from RawTable   group by name, pre  ) as R2    on R1.name = R2.name and       R1.pre = R2.pre and       R1.groupid = R2.groupid