1.删除表中多余的重复记录,只保留ID为最小的记录.(多个字段)
DELETE FROM XY_PRICEENTRY WHERE CUSABB IN
(SELECT CUSABB FROM XY_PRICEENTRY GROUP BY CUSABB HAVING COUNT(*)>1)
AND ITEM IN(SELECT ITEM FROM XY_PRICEENTRY GROUP BY ITEM HAVING COUNT(*)>1)
AND MINQTY IN(SELECT MINQTY FROM XY_PRICEENTRY GROUP BY MINQTY HAVING COUNT(*)>1)
AND ID NOT IN(SELECT MIN(ID) FROM XY_PRICEENTRY GROUP BY CUSABB,ITEM,MINQTY HAVING COUNT(*)>1)