假设表中的组合(person_id, car_id)是唯一的，则可以执行以下操作：
delete from car_assignment
where (person_id, car_id)
in (select person_id, car_id
from (
select person_id,
car_id,
row_number() over (partition by person_id order by car_id) as rn
from car_assignment
) t
where rn > 2);
602392714
清零编程群