如何删除表中的重复行

drop table if exists duplicates;

CREATE TABLE duplicates (col1 INT, col2 VARCHAR(100));

INSERT INTO duplicates VALUES (1, 'test1'), (2, 'test1'), (3, 'test2'), (4, 'test3'), (5, 'test2');

-- 使用MySQL的GROUP BY和ORDER BY语句来实现删除重复数据的功能
DELETE FROM duplicates
WHERE col1 = (
    SELECT MIN(col1)
    FROM (
        SELECT col1
        FROM duplicates
        GROUP BY col1, col2
        ORDER BY col1 DESC
    ) AS min_duplicates
);