摘要:
http://wenku.baidu.com/view/1cf16d4de518964bcf847c16.html 阅读全文
摘要:
http://www.cnblogs.com/stevenshi/archive/2010/12/14/1906072.html 阅读全文
摘要:
select name , SUM(case when SUBSTRING(convert(varchar(7),date,120),6,2)in ('01','02','03') then yeji else 0 end) as '第一季度' ,SUM(case when SUBSTRING(convert(varchar(7),date,120),6,2) in ('04','05','06') then yeji else 0 end) as '第二季度',SU 阅读全文