单选题

下列正确的去重语句是

Question

A. delete from tableName where tableName.key not in (select max(key) from tableName group by field_1,field_2 having count(1) > 1)

B. delete from tableName where tableName.key in (select max(key) from tableName group by field_1,field_2 having count(1) > 1)

C. delete from tableName where tableName.key not in (select min(key) from tableName group by field_1,field_2 having count(1) > 1)

D. delete from tableName t1 where t1.key not in (select max(key) from tableName group by field_1,field_2 having count(1) > 1) and exists ( select 1 from tableName where tableName.key=t1.key group by field_1,field_2 having count(1) > 1)