22,206
社区成员
发帖
与我相关
我的任务
分享
select visit_date,user_id,count(1) as num
from (
select visit_date,user_id ,visit_IP
from table_visit_record group by visit_date, user_id,visit_IP) a
select visit_date,[user_id],count(*) as num from(
select distinct visit_date,[user_id] ,visit_IP from table_visit_record
)t group by visit_date, [user_id]
select visit_date,user_id,count(*) as num from(
select distinct visit_date,user_id ,visit_IP from table_visit_record
)t group by visit_date, user_id