SQL列转行

 

  select a.ID,
    case b.flag when 1 then AA
       when 2 then BB
       when 3 then CC
       else DDend as PartNoID

  from Quo_A as a
  Join(select 1 as flag union select 2 as flag union select 3 as flag union
    select 4 as flag) as b  on 1=1

 

 

select 1 as flag的作用就是创建一行同样的记录，因为有4个列要转成4行，所以select4次