SELECT
name
FROM
Mytable
GROUP BY
name
HAVING
COUNT(*) > 1
要也区分性别,请将GROUP BY更改为 name, gender
删除重复的行
DELETE MyTable
WHERE ID NOT IN
(
SELECT
MIN(Id)
FROM
Mytable
GROUP BY
name
)
我可以提取在sql中重复的提取记录吗?
SELECT
name
FROM
Mytable
GROUP BY
name
HAVING
COUNT(*) > 1
要也区分性别,请将GROUP BY更改为 name, gender
删除重复的行
DELETE MyTable
WHERE ID NOT IN
(
SELECT
MIN(Id)
FROM
Mytable
GROUP BY
name
)