结果集A:
转换成为结果集B:
mysql中实现例如以下:
SELECT a.biz_date, CASE WHEN a.`event` = 'downClick' THEN a.uv END AS downClick, CASE WHEN a.`event` = 'successClick' THEN a.uv END AS successClick, CASE WHEN a.`event` = 'installSuccess' THEN a.uv END AS installSuccess from a
原文：http://www.cnblogs.com/mengfanrong/p/5185054.html
