-- 删除重复记录
DELETE
FROM zz_access_last
WHERE userid IN(SELECT
userid
FROM (SELECT
userid
FROM zz_access_last
GROUP BY userid
HAVING COUNT(userid) > 1) a)
AND rid NOT IN(SELECT
*
FROM (SELECT
MIN(rid)
FROM zz_access_last
GROUP BY userid
HAVING COUNT(userid) > 1) b)