添加一些数据
使用如下语句删除重复记录:
DELETE
FROM
test
WHERE
id NOT IN (
SELECT
id
FROM
(
SELECT
min(id) id
FROM
test
GROUP BY
aa
) t
)
添加一些数据
使用如下语句删除重复记录:
DELETE
FROM
test
WHERE
id NOT IN (
SELECT
id
FROM
(
SELECT
min(id) id
FROM
test
GROUP BY
aa
) t
)