Seleziona i record più presenti in tabella

[willybit]

SELECT * FROM(SELECT Cognome, COUNT(Cognome) AS Quantita FROM dati GROUP BY Cognome) ORDER BY Quantita DESC