如何根据MySQL中的2列删除与前一行的值匹配的下一行

SELECT t1.column1, t1.column2, t2.column1, t2.column2
FROM table_name t1
JOIN table_name t2 ON t1.column1 = t2.column1 AND t1.column2 = t2.column2

SELECT t1.column1, t1.column2
FROM (
    SELECT column1, column2, LEAD(column1) OVER (ORDER BY column1, column2) AS next_column1
    FROM table_name
) t1
WHERE t1.column1 = t1.next_column1

DELETE FROM table_name
WHERE (column1, column2) IN (
    SELECT t1.column1, t1.column2
    FROM (
        SELECT column1, column2, LEAD(column1) OVER (ORDER BY column1, column2) AS next_column1
        FROM table_name
    ) t1
    WHERE t1.column1 = t1.next_column1
)