Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- need help with a query to count distinct items
GaryK - 12:02 am on Nov 23, 2010 (gmt 0)
Aren't you missing "as hits" and a group by clause? Also, won't your Count(DISTINCT IPAddress) always return a value of 1?
Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4230869.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com