Cache SQL - Distinct - Count

[Dipl.-Ing. Werner Riegler]

Does anybody know how to solve this as a single sql query:

count each occurence of a value in a columns

e.g. a table with IP adresses from a web server log and count how often each
IP address is listed ?

werner