我来个有病SQL开火车模式
- select j1.* from
- (select 商品ID,统计日期,商品流量 as 近1天商品流量,支付件数 as 近1天支付件数,支付金额 as 近1天支付金额,0 as 近2天商品流量,0 as 近2天支付件数,0 as 近2天支付金额,0 as 近3天商品流量,0 as 近3天支付件数,0 as 近3天支付金额 from [数据源$] where day(统计日期)=(day(now()))) j1
- UNION ALL
- select j2.* from
- (select 商品ID,统计日期,0 as 近1天商品流量,0 as 近1天支付件数,0 as 近1天支付金额,商品流量 as 近2天商品流量,支付件数 as 近2天支付件数,支付金额 as 近2天支付金额,0 as 近3天商品流量,0 as 近3天支付件数,0 as 近3天支付金额 from [数据源$] where day(统计日期)=(day(now())) union all
- select 商品ID,统计日期,0 as 近1天商品流量,0 as 近1天支付件数,0 as 近1天支付金额,商品流量 as 近2天商品流量,支付件数 as 近2天支付件数,支付金额 as 近2天支付金额,0 as 近3天商品流量,0 as 近3天支付件数,0 as 近3天支付金额 from [数据源$] where day(统计日期)=(day(now())-1)) j2
- UNION ALL
- select j3.* from
- (select 商品ID,统计日期,0 as 近1天商品流量,0 as 近1天支付件数,0 as 近1天支付金额,0 as 近2天商品流量,0 as 近2天支付件数,0 as 近2天支付金额,商品流量 as 近3天商品流量,支付件数 as 近3天支付件数,支付金额 as 近3天支付金额 from [数据源$] where day(统计日期)=(day(now())) union all
- select 商品ID,统计日期,0 as 近1天商品流量,0 as 近1天支付件数,0 as 近1天支付金额,0 as 近2天商品流量,0 as 近2天支付件数,0 as 近2天支付金额,商品流量 as 近3天商品流量,支付件数 as 近3天支付件数,支付金额 as 近3天支付金额 from [数据源$] where day(统计日期)=(day(now())-1) union all
- select 商品ID,统计日期,0 as 近1天商品流量,0 as 近1天支付件数,0 as 近1天支付金额,0 as 近2天商品流量,0 as 近2天支付件数,0 as 近2天支付金额,商品流量 as 近3天商品流量,支付件数 as 近3天支付件数,支付金额 as 近3天支付金额 from [数据源$] where day(统计日期)=(day(now())-2)) j3
复制代码
|