contare i duplicati in mysql

[alcatraz69]

SELECT lettera, COUNT(lettera) AS numero FROM tabella GROUP BY lettera
ORDER BY numero DESC

ciao