SELECT        COUNT(CODEJR) AS exp, CODEJR, PREFIX, NUMERO
FROM            PIECE
GROUP BY CODEJR, PREFIX, NUMERO
HAVING        (COUNT(CODEJR) > 1)