dhl:SQL-统计每天的PV和UV

最新推荐文章于 2022-02-21 21:04:20 发布

weixin_30824599

最新推荐文章于 2022-02-21 21:04:20 发布

阅读量625

点赞数

文章标签：测试

原文链接：http://www.cnblogs.com/dudu837/archive/2010/06/18/1760379.html

版权

--PV:
select page as 地址,convert(char(10),createtime,120) as 时间,count(*) as 访问量
from dbo.WebAppLog
where convert(char(10),createtime,120)>='2010-06-01' and Page='http://app.pingco.cn/NewCall/Call.mvc/index'
group by page, convert(char(10),createtime,120)
order by convert(char(10),createtime,120)

--UV:
select max(page) as 地址, convert(char(10),createtime,120) as 时间,count(distinct(mobile)) as 人数
from dbo.WebAppLog
where convert(char(10),createtime,120)>='2010-06-01' and page = 'http://app.pingco.cn/NewCall/Call.mvc/index'
group by convert(char(10),createtime,120)
order by convert(char(10),createtime,120)

转载于:https://www.cnblogs.com/dudu837/archive/2010/06/18/1760379.html