摘要： ---恢复内容开始---实例：empidcustidqty2A523A201B202B271C343C223D30要求转换后的透视图如下：empidABCD1NULL2034NULL25227NULLNULL320NULL22301.标准sql 进行透视转换 select empid, sum(case when custid ='A' then qty End) AS A, sum(case when custid ='B' then qty End) AS B, sum(case when custid ='C' then qty End) 阅读全文