1、删除数据库中重复数据,保留id最小的
DELETE
FROM
brand
WHERE
brandName
IN
(
SELECT
brandName
FROM
(
SELECT
brandName
FROM
brand
GROUP
BY
brandName
HAVING
COUNT
(brandName)>1) e)
AND
Id
NOT
IN
(
SELECT
Id
FROM
(
SELECT
MIN
(Id)
AS
Id
FROM
brand
GROUP
BY
brandName
HAVING
COUNT
(brandName)>1) t)