oracel pivot行列转置

 1 select * from 
 2             (select cd,nm,num,js from test where  rq='avc')
 3             pivot (sum(js) for num in('Y20','J31','X47B'))
 4 
 5 
 6 
 7 EXTEND
 8 
 9 
10 select row_number() over (order by cd) rn, t.*  from
11             (select cd,nm,num,js from test where  rq='avc')
12             pivot (sum(js) for num in('Y20','J31','X47B')) t
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/conserdao/p/8776974.html