sql删除重复记录

delete from Rebate_Logs where id not in (select max(id) from Rebate_Logs  group by  usercode_sk,ordercode)