尝试获取每个不同用户每天的登录次数。但是,我的查询没有按日期分组:
DECLARE @StartDate AS Date
SET @StartDate = DATEADD(dd,-30,GETDATE())
SELECT CAST(ml.login_time AS date) AS Date_Login
,COUNT(DISTINCT ml.email) AS Total
FROM database.login AS ml
WHERE 1=1
AND ml.login_time > @StartDate
GROUP BY ml.login_time
ORDER BY ml.login_time DESC
输出结果如下所示:
2018-12-11 1
2018-12-11 5
2018-12-11 2
2018-12-11 2
2018-12-11 1
2018-12-11 3
2018-12-10 1
2018-12-10 2
2018-12-10 3
https://stackoverflow.com/questions/53734208
复制相似问题