作者:孤魂地狱 | 来源:互联网 | 2018-04-17 09:32
结果集A:转换成为结果集B:mysql中实现如下:SELECTabiz_date,CASEWHENa`event`39;downClick39;THENauvENDASdownClick,CASEWHENa`event`39;successClic
结果集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