我试图在一个case语句中使用Max(date)汇总当天的数字,并使用-interval汇总前一天的数字。
select
product,sum(
case
when date_started = max(date_started)
then volume
end
)
as "Current day's Volume",sum(
case
when date_started = max(date_started)
then revenue
end
)
as "Current day's Revenue",sum(
case
when date_started = (max(date_started) - interval '1 day' then volume end) as "Current day's Volume",sum(
case
when date_started = (max(date_started) - interval '1 day' then revenue end) as "Current day's Revenue"
from
[lifetime_data]
group by
1
这是在PostgreSQL上。它不起作用,对我来说也没有明显的错误。