春哥也编程

摘要： 例如：oldXml<object datePoint="2011-03-05" PT_staticCount="3" UOC_staticCount="3"/><object datePoint="2011-03-06" PT_staticCount="5" UOC_staticCount="9"/><object datePoint="2011-03-07" PT_staticCount="9" UOC_ 阅读全文

摘要： 例如：如下图所示，对数据库的EmailSource字段按日期分类汇总因此我们可以写入如下的SQL语句类解决这样的问题SELECT sum(case when `EmailSource`='FM' then 1 else 0 end) as FM_Statistic,sum(case when `EmailSource`='UOC' then 1 else 0 end) as UOC_Statistic,sum(case when `EmailSource`='OC' then 1 else 0 end) as OC_Statistic,DATE_ 阅读全文