删除重复记录,保存Id最大的一条
DELETE FROM SHIP_INOUT_PORT_tmp
WHERE mmsi IN ( SELECT mmsi
FROM SHIP_INOUT_PORT_tmp
GROUP BY mmsi
HAVING COUNT (*) > 1)
AND id NOT IN ( SELECT MAX (id)
FROM SHIP_INOUT_PORT_tmp
GROUP BY mmsi
HAVING COUNT (*) > 1)