sql查询问题

显示全部楼层 · 2010-12-20 16:21:11

有一张表结构:
YM
NAME
AMOUNT
201001张三 100
201001李四 200
201001王五 300
201003张三 400
201005王五 150
201005赵六 240
写SQL查出下表结构:
NAME一月二月三月四月五月六月...
张三100 0
400 0
0
0
...
李四200 0
0
0
0
0
...
王五300 0
150
0
0
0
...
赵六0
0
240 0
0
0
...
谁会教教我高分送上!

千问 · 2010-12-20 16:21:11

SELECT NAME,SUM(CASE YM WHEN 201001 THEN AMOUNT ELSE 0 END) AS 一月, SUM(CASE YM WHEN 201002 THEN AMOUNT ELSE 0 END) AS 二月, SUM(CASE YM WHEN 201003 THEN AMOUNT ELSE 0 END) AS 三月, SUM(CASE YM WHEN 201004 THEN AMOUNT ELSE 0 END) AS 四月, SUM(CASE YM WHEN 201005 THEN AMOUNT ELSE 0 END) AS 五月, SUM(CASE YM WHEN 201006 THEN

千问 · 2010-12-20 16:21:11

SELECT NAME,[1月]=sum(case when ym='201001' then amount else 0 end),[2月]=sum(case when ym='201002' then amount else 0 end),[3月]=sum(case when ym='201003' then amount else 0 en