contare campi uguali

[piero.mac]

SELECT *,
COUNT(*) as tot
FROM tabella
GROUP BY nome, cognome