1、 SELECT T1,T2,T3 FROM TABLE Group by t1,t2,t3 having count(*) >1 查找重复记录
2、 DELETE FROM TABLE WHERE ID NOT IN (SELECT MAX(ID) FROM TABLE GROUP BY T1,T2,T3) 按条件删除重复记录
2、 DELETE FROM TABLE WHERE ID NOT IN (SELECT MAX(ID) FROM TABLE GROUP BY T1,T2,T3) 按条件删除重复记录
