我有下表
CREATE TABLE history (
id VARCHAR,
a_date DATE,
logins INTEGER
);
我不确定为什么使用以下命令时会出错：
SELECT a_date
, SUM(logins) AS total_logins
, VARIANCE(logins) AS varince_over_time
FROM history
WHERE
a_date BETWEEN '2018-05-10' AND '2018-05-30'
即使我运行时效果很好：
SELECT a_date
FROM history
WHERE
a_date
BETWEEN '2018-05-10' AND '2018-05-30'
要么
SELECT a_date
, SUM(logins) AS total_logins
, VARIANCE(logins) AS varince_over_time
FROM history
GROUP BY a_date
所以不确定什么是实际的问题
SELECT a_date
, SUM(logins) AS total_logins
, VARIANCE(logins) AS varince_over_time
FROM history
WHERE
a_date BETWEEN '2018-05-10' AND '2018-05-30'
谢谢，任何帮助！
如果要使用聚合函数（例如），则仍然需要GROUP BY SUM。
SELECT a_date,
SUM(logins) AS total_logins,
VARIANCE(logins) AS varince_over_time
FROM history
WHERE a_date BETWEEN '2018-05-10' AND '2018-05-30'
GROUP BY a_date;
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句