34,587
社区成员
发帖
与我相关
我的任务
分享
SELECT pk_id,fullname,mobilephone,email,value,codes
FROM tablename
unpivot (value for codes in (
reson,fk_resumeid,fk_ompanyid...
)) t
差不多这个结构拿去试试SELECT [1] stander ,
[2] pro ,
[3] AS enterprise
FROM tbl_MBS_TEST PIVOT
( SUM(sl) FOR serverType IN ( [1], [2], [3], [4] ) )as pv