删除所有值比第二高的值低5倍的记录

删除所有值比第二高的值低5倍的记录

DELETeFROM myTableWHERe ID IN (    SELECt *    FROM (        SELECt t2.id        FROM myTable t2        WHERe EXISTS ( SELECt 1 FROM myTable t3 WHERe t3.pre = t2.pre AND t3.price > t2.price * 5 HAVINg COUNT(*) > 1 )    ) t);