DWarp9 - 8:49 am on Nov 16, 2010 (gmt 0)

Hi Gary,

This should do the trick:

SELECT Count(*) as hits, IPAddress From IPAddresses Group By IPAddress Order by hits desc;

Hope this help.
-Peter