只需将 time 添加到您的 GROUP BY 子句中就可以了：
time
GROUP BY
SELECT `time`, count(ip) AS clicks, ip FROM wmf24_statpress WHERE urlrequested LIKE '%gclid=%' GROUP BY `time`, ip
此外，您不需要 distinct 子句
distinct
Just add time to your GROUP BY clause and you should be fine:
Also, you don't need the distinct clause
按时间和 ip 进行分组以删除重复项，但仍然可以看到重复项，即
SELECT wmf24_statpress.time, count(ip) AS clicks, ip FROM wmf24_statpress WHERE urlrequested LIKE '%gclid=%' GROUP BY wmf24_statpress.time, ip
Group by both time and ip to remove duplicates and still see repeats, i.e.
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
暂无简介
文章 0 评论 0
接受
发布评论
评论（2）
只需将
time添加到您的GROUP BY子句中就可以了：此外，您不需要
distinct子句Just add
timeto yourGROUP BYclause and you should be fine:Also, you don't need the
distinctclause按时间和 ip 进行分组以删除重复项，但仍然可以看到重复项，即
Group by both time and ip to remove duplicates and still see repeats, i.e.