正文

sql server 多列转多行实现方法

IP云
IP云V管理员/5 阅读
08/23
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

select * from b_workOrder

select * from( SELECT work_order_id,work_level, roles,code
FROM
(SELECT work_order_id,work_level,operator_code,sqc_code,hqc_code
FROM b_workOrder where sqc_code <>'') p
UNPIVOT
(code FOR roles IN (operator_code,sqc_code,hqc_code))
AS unpvt) as a