Delete en una consulta

[quimfv]

TODOS?

Si tienes un identificador único es fácil

Código MySQL:

SELECT idAlumno INTO TablaTemporal
FROM alumno
GROUP BY cod_alu, ape_pat, ape_mat
HAVING COUNT( * ) >1;
 
DELETE FROM alumno WHERE  idAlumno IN (SELECT idAlumno FROM TablaTemporal);
 
DROP TABLE TablaTemporal;