db 중복 row 제거 쿼리

중복제거.sql

DELETE
FROM log_by_hour
WHERE id IN
(
    SELECT id FROM (SELECT max(id) FROM log_by_hour where time BETWEEN FROM_UNIXTIME(1598927371) AND FROM_UNIXTIME(1598956231) GROUP BY instance_id, cmd_id, time, min, max, avg HAVING count(*) > 1) temp_table
)
and time BETWEEN FROM_UNIXTIME(1598927371) AND FROM_UNIXTIME(1598956231)
;

DELETE
FROM log_by_minute
WHERE id IN
(
    SELECT id FROM (SELECT max(id) FROM log_by_minute  where time BETWEEN FROM_UNIXTIME(1598927371) AND FROM_UNIXTIME(1598956231) GROUP BY instance_id, cmd_id, time, min, max, avg HAVING count(*) > 1) temp_table
)
and time BETWEEN FROM_UNIXTIME(1598927371) AND FROM_UNIXTIME(1598956231)
;