BlogJava-spinage-最新评论http://www.blogjava.net/spinage/CommentsRSS.aspxzh-cnSun, 24 Apr 2011 14:46:52 GMTSun, 24 Apr 2011 14:46:52 GMTcnblogsre: SQL经典面试题及答案http://www.blogjava.net/spinage/archive/2009/11/27/299911.html#303960HarryGodHarryGodFri, 27 Nov 2009 10:28:00 GMThttp://www.blogjava.net/spinage/archive/2009/11/27/299911.html#303960

HarryGod 2009-11-27 18:28 发表评论
]]>re: SQL经典面试题及答案http://www.blogjava.net/spinage/archive/2009/11/27/299911.html#303958HarryGodHarryGodFri, 27 Nov 2009 10:26:00 GMThttp://www.blogjava.net/spinage/archive/2009/11/27/299911.html#303958sum(case when b.mon=1 then b.yj else 0 end) as '一月份',
sum(case when b.mon=2 then b.yj else 0 end) as '二月份',
sum(case when b.mon=3 then b.yj else 0 end) as '三月份',
sum(case when b.mon=4 then b.yj else 0 end) as '四月份',
sum(case when b.mon=5 then b.yj else 0 end) as '五月份',
sum(case when b.mon=6 then b.yj else 0 end) as '六月份',
sum(case when b.mon=7 then b.yj else 0 end) as '七月份',
sum(case when b.mon=8 then b.yj else 0 end) as '八月份',
sum(case when b.mon=9 then b.yj else 0 end) as '九月份',
sum(case when b.mon=10 then b.yj else 0 end) as '十月份',
sum(case when b.mon=11 then b.yj else 0 end) as '十一月份',
sum(case when b.mon=12 then b.yj else 0 end) as '十二月份'
from table2 a left join table1 b on a.dep=b.dep group by a.dep;

HarryGod 2009-11-27 18:26 发表评论
]]>