将后面对应的 SALE_QTY SALE_VALUE RETAIL_VALUE DISTRI_VALUE 根据时间YEAR_CODE 转成列
SELECT * FROM (
SELECT * FROM xxx_x
)
PIVOT(SUM(sales_qty) qty,
SUM(sales_value) sa_val,
SUM(retail_value) re_val,
SUM(distri_value) dis_val
FOR YEAR_CODE IN ('2022' AS e22 ,'2021' AS e21,2020 AS e20,'2019' AS e19))
各个SUM 命别名,生成的结果 会以 别名与IN 里面对应的YEAR_CODE 值别名组合 e22_QTY
木庄网络博客(2016/10/28 11:41:03)
不错的网站主题,看着相当舒服