delete from aop_app_ipmlinfo a where a.impl_id not in
(
  select max(t.impl_id) c from aop_app_ipmlinfo t group by t.app_id,t.ability_id
)

ps: max(t.impl_id) 也能替换为 min(t.impl_id)