[ecfisa]

Hola MAXIUM.

Un modo es:

Código SQL [-]
SELECT APEL_PATER, APEL_MATER, NOMBRE
FROM TU_TABLA
WHERE APEL_PATER IN (SELECT APEL_PATER FROM TU_TABLA
      GROUP BY APEL_PATER HAVING COUNT(*) > 1 )
  AND NOMBRE IN (SELECT NOMBRE FROM TU_TABLA
      GROUP BY NOMBRE HAVING COUNT(*) > 1 )
ORDER BY APEL_PATER

Saludos