SQL - Consulta SQL para valores repetidos

Supongamos que tengo la tabla "player_skills", entonces los campos de cada jugador son: player_id, skillid, value, count .
Supongamos que por default son asi:

player_id, skillid, value, count:
24 0 10 50
24 1 10 50
24 2 10 50
24 3 10 50
24 4 10 50
24 5 10 50
24 6 10 50


Pero derrepente estos valores se duplican, o se triplican de tal forma que quedan asi:
player_id, skillid, value, count:
24 0 10 50
24 1 10 50
24 2 10 50
24 3 10 50
24 4 10 50
24 5 10 50
24 6 10 50
24 0 10 50
24 1 10 50
24 2 10 50
24 3 10 50
24 4 10 50
24 5 10 50
24 6 10 50



en realidad no se porque es culpa del problema que los maneja, pero quisiera saber si me pudieran decir una consulta sql, para encontrar valores repetidos, o eliminarlos, sin eliminar los valores normales. Gracias

/* Obtienes los registros repetidos */
SELECT player_id,
skillid,
[value],
[count],
Count(*) AS 'cantidad'
FROM player_skills
GROUP BY player_id,
skillid,
[value],
[count]
ORDER BY 5

/* Depuraras la tabla */
SELECT DISTINCT player_id,
skillid,
[value],
[count]
INTO ##player_skills_temp
FROM player_skills

TRUNCATE TABLE player_skills

INSERT INTO player_skills
(player_id,
skillid,
[value],
[count])
SELECT player_id,
skillid,
[value],
[count]
FROM ##player_skills_temp

DROP TABLE ##player_skills_temp

/*
Obtienes los registros repetidos
luego de la limpieza
*/

SELECT player_id,
skillid,
[value],
[count],
Count(*) AS 'cantidad'
FROM player_skills
GROUP BY player_id,
skillid,
[value],
[count]
ORDER BY 5