1、静态的行转列
sql代码:
SELECT
start_dt,
MAX(CASE type_name WHEN '总的参与人数' THEN VALUE END) AS '总的参与人数',
MAX(CASE type_name WHEN '会员参与人数' THEN VALUE END) AS '会员参与人数',
MAX(CASE type_name WHEN '普免参与人数' THEN VALUE END) AS '普免参与人数',
MAX(CASE type_name WHEN '首次参与活动的用户数' THEN VALUE END) AS '首次参与活动的用户数'
FROM v_stat_daily_activity_warrior
GROUP BY start_dt
转换前:
转换后:
更详细参考:
http://blog.csdn.net/kiki113/article/details/4105929
http://blog.itpub.net/26245823/viewspace-1117921/