sql表中多列转一行

1.一个表中，把后面的多列数据重复在同一行展示

原始表Atest,字段如下第二列

 

展示一行格式

sql语句

SELECT  op_time,name,sourcename,
SUM(IF(result ='认证通过',opnum9~12,0)) opsucc9~12,
SUM(IF(result ='认证通过',opnum12~15,0)) opsucc12~15,
SUM(IF(result ='认证通过',opnum15~18,0)) opsucc15~18,
SUM(IF(result ='认证不通过',opnum9~12,0)) opfail9~12,
SUM(IF(result ='认证不通过',opnum12~15,0)) opfail12~15,
SUM(IF(result ='认证不通过',opnum15~18,0)) opfail15~18,
SUM(IF(result ='无认证',opnum9~12,0)) opno9~12,
SUM(IF(result = '无认证',opnum12~15,0)) opno12~15,
SUM(IF(result = '无认证',opnum15~18,0)) opno15~18
FROM Atest
GROUP BY op_time,name,sourcename