MS SQL 行转列问题 转列后数据不正确

Question

select user_no,1 as a,2 as b,3 as c,4 as d from (select user_no,uk,sj from b) as ccccpivot (max(sj) for uk in([1],[2],[3],[4])) as pvt; 这语句转列处理为什么没有时间

Answer 1

当然没有时间，因为你输出的就是常量：1 as a,2 as b,3 as c,4 as d 。
你把“1 as a,2 as b,3 as c,4 as d ”换成 sj 就可以了。