语句简化

yekai_hua

SELECT md,(select sum (tt.xs) from tt where yf= 1 and md = "aa") as 1y,(select sum (tt.xs) from tt where yf= 2 and md = "aa") as 2y,(select sum (tt.xs) from tt where yf= 3 and md = "aa") as 3y
FROM tt
where md = "aa"
GROUP BY tt.md
UNION ALL
SELECT md,(select sum (tt.xs) from tt where yf= 1 and md = "bb") as 1y,(select sum (tt.xs) from tt where yf= 2 and md = "bb") as 2y,(select sum (tt.xs) from tt where yf= 3 and md = "bb") as 3y
FROM tt
where md = "bb"
GROUP BY tt.md
UNION ALL SELECT md,(select sum (tt.xs) from tt where yf= 1 and md = "cc") as 1y,(select sum (tt.xs) from tt where yf= 2 and md = "cc") as 2y,(select sum (tt.xs) from tt where yf= 3 and md = "cc") as 3y
FROM tt
where md = "cc"
GROUP BY tt.md;
麻烦那位大虾帮忙简化下以上这段东东

ycxchen

看似天书，没有例子谁知是什么东东？

yekai_hua

门店号 月份  销售
aa       1       1
aa       2       2
aa       3       3
bb       1       4
bb       2       5
bb       3       6
cc        1       7
cc        2       8
cc        3       9

yekai_hua

把上面那个表按门店 月份汇总
结果为
     1月 2月 3月
aa   1    2    3
bb   4    5    6
cc    7    8    9

andymark

晕死,用交叉表来处理呀

yekai_hua

交叉表
萨意思请指教

yekai_hua

TRANSFORM Sum(tt.[xs])
SELECT tt.[md]
FROM tt
GROUP BY tt.[md]
PIVOT tt.[yf];
已简化 分享下呵呵 谢谢楼上的大哥