如何创建一个查询一个表并希望返回多个子句,但每列有不同条件的查询。最后我还需要一个group by子句。如下所示,我的括号是psuedocode:
Select date, sum(revenue) [where source = X], sum (revenue [where source = Y]
from table1
group by date这是可能的吗?或者我只需要执行不同的查询
发布于 2021-01-20 02:07:32
使用条件聚合:
select date,
sum(case when source = 'X' then revenue end) as x_revenue,
sum(case when source = 'Y' then revenue end) as y_revenue
from t
group by date;https://stackoverflow.com/questions/65797047
复制相似问题