MYSQL数据的行列置换
摘要：
脚本： select stat_date,class_id, case when origin ='ad' then sum(pv) else 0 end as m1, case when origin'ad' then sum(pv) else 0 end as m2 from t_stat_goods_page_by_hour where datediff(stat_date,'2008-12... 阅读全文
posted @ 2008-12-24 11:17 马森 阅读(289) 评论(0) 推荐(0) 编辑
