假设我有一列日期、类别和值要求和。我希望按类别分组,并对值进行求和,使其在某一组日期上满足某些条件,而在另一组日期上满足另一个条件。
类似于:
SELECT categories, SUM(values)
FROM table
group by categories
having SUM(values) = 0 WHEN dates between w AND x
AND having SUM(values) > 10000 WHEN dates between y and z谢谢!
发布于 2018-05-30 16:00:01
我认为您需要有条件的聚合:
select categories, sum(values)
from table
group by categories
having sum(case when dates between w and x then values else 0 end) = 0 and
sum(case when dates between y and z then values else 0 end) > 10000 ; 发布于 2018-05-30 16:07:03
您可以执行以下操作(SUM值仅适用于IIF子句中尊重条件的值):
SELECT categories, SUM(values)
FROM table
GROUP BY categories
HAVING SUM(IIF(dates BETWEEN w AND x, values, 0)) = 0
AND SUM(IIF(dates BETWEEN y AND z, values, 0)) > 10000 https://stackoverflow.com/questions/50608978
复制相似问题