SQL行转列问题求教
t1表结构如下:
提示报错为t2中SELECT语句,不明白问题出在何处,还望坛友不吝赐教
with t1 as (
SELECT
入库日期,入库级别,
ROUND(sum((重量/1000)),3) as "重量1"
FROM jl_ccp
WHERE 入库类别='正常入库' AND 入库日期>="2023-09-01"
GROUP BY 入库日期,入库级别
)
t2 as(
SELECT 入库日期,
sum(CASE WHEN 入库级别='SE2GA' THEN '重量1' ELSE 0 END) 'SE2GA',
sum(CASE WHEN 入库级别='SEGA' THEN '重量1' ELSE 0 END) 'SEGA',
sum(CASE WHEN 入库级别='SHGA' THEN '重量1' ELSE 0 END) 'SHGA'
FROM t1
GROUP BY 入库日期
)
-- SELECT * FROM t1 ;
SELECT * FROM t2;
推荐文章: