22,210
社区成员
发帖
与我相关
我的任务
分享
select left(dt,7) as 时间,sum(cnt) as 登录次数
from
(
select convert(varchar(10),loginDate,120) as dt,count(distinct uid) as cnt
from tb
group by convert(varchar(10),loginDate,120) as dt
) t
group by left(dt,7)