Page is a not externally linkable
- Code, Content, and Presentation
---- need help with a query to count distinct items
DWarp9 - 8:49 am on Nov 16, 2010 (gmt 0)Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4230869.htm
This should do the trick:
|SELECT Count(*) as hits, IPAddress From IPAddresses Group By IPAddress Order by hits desc; |
Hope this help.
Brought to you by WebmasterWorld: http://www.webmasterworld.com