è semplice
codice:
SELECT count(*) as Counter,MyField FROM MyTable GROUP BY MyField ORDER BY MyField