Question

ASP 数据库去除重复后统计问题

SELECT count(Record_ip) as tongji,man from Record where
year(date) = year(now) and month(date) = month(now) group by man

man:是要统计的姓名
Record：是数据库表单名
Record_ip：是IP地址
上述是统计一个月内全部用户的IP
请问如何去掉重复的IP后再统计？

Answer 1

SELECT COUNT(DISTINCT Record_ip) as tongji,man from Record where
year(date) = year(now) and month(date) = month(now) group by man