如何在SQL中找到重复的条目并删除最旧的条目？

SELECT column1, column2, ..., columnN, COUNT(*) as count
FROM table_name
GROUP BY column1, column2, ..., columnN
HAVING count > 1

SELECT column1, column2, ..., columnN, MIN(timestamp_column) as oldest_timestamp
FROM table_name
GROUP BY column1, column2, ..., columnN

DELETE FROM table_name
WHERE (column1, column2, ..., columnN, timestamp_column) IN (
    SELECT column1, column2, ..., columnN, MIN(timestamp_column) as oldest_timestamp
    FROM table_name
    GROUP BY column1, column2, ..., columnN
    HAVING COUNT(*) > 1
)