MySQL COUNT DISTINCT [英] MySQL COUNT DISTINCT

问题描述

我正试图收集昨天在我的客户服务中进行的不重复访问的次数，然后对它们进行计数.

I'm trying to collect the number of distinct visits in my cp yesterday, then count them.

SELECT
    DISTINCT `user_id` as user,
    `site_id` as site,
    `ts` as time
FROM
    `cp_visits`
WHERE
    ts >= DATE_SUB(NOW(), INTERVAL 1 DAY)

由于某种原因，这会以相同的站点ID提取多个结果....我如何仅提取和计算不同的site_id cp登录数?

For some reason this is pulling multiple results with the same site id....how do i only pull and count the distinct site_id cp logins?

推荐答案

 Select
     Count(Distinct user_id) As countUsers
   , Count(site_id) As countVisits
   , site_id As site
 From cp_visits
 Where ts >= DATE_SUB(NOW(), INTERVAL 1 DAY)
 Group By site_id

这篇关于MySQL COUNT DISTINCT的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！