先找出相同行的id,sql如下:
SELECT
DISTINCT(t_s.id)
FROM
`t_score` t_s
INNER JOIN ( SELECT * FROM t_score ) AS ts ON t_s.NAME = ts.NAME
AND t_s.score = ts.score
AND t_s.id != ts.id
order by t_s.id asc;
如果删除的话,在这个基础上,再加一层删除操作:
DELETE
FROM
t_score
WHERE
id IN (
SELECT
a.id
FROM
(
SELECT DISTINCT
( t_s.id ) AS id
FROM
`t_score` t_s
INNER JOIN ( SELECT * FROM t_score ) AS ts ON t_s.NAME = ts.NAME
AND t_s.score = ts.score
AND t_s.id != ts.id
ORDER BY
t_s.id ASC
) a
);
亲测有效,希望可以帮助你!(不要忘了给分哦!)