mysql结果集合切换_MySQL

来源：气奇美食网

结果集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

违法及侵权请联系：TEL:199 18 7713 E-MAIL:2724546146@qq.com

本站由北京市万商天勤律师事务所王兴未律师提供法律服务