SELECT TO_CHAR(T.VISIT_DATE, 'HH24') AS VISITTIME, COUNT(DISTINCT T.VISIT_SESSIONS_ID) AS VISITERCOUNT, COUNT(DISTINCT T.VISIT_IP) AS IPCOUNT, COUNT(T.PAGE) AS PAGECOUNT FROM TB_STATISTIC_DETAIL T WHERE TO_CHAR(T.VISIT_DATE, 'YYYY-MM-DD') = '2009-12-31' GROUP BY TO_CHAR(T.VISIT_DATE, 'HH24') 本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/thismonth/archive/2009/12/31/5110871.aspx
查询某天每个时段的访问数据(网站流量统计)
最新推荐文章于 2020-12-10 03:23:19 发布