sql - postgresql 中的数据透视表

Question

我有什么

customerid   status

   Ax         1    
   Bx         3
   Cx         5
   Dx         4
   Ex         2

我希望在 table 上方旋转。

我需要什么

customerid   status_1 status_2 status_3 status_4 status_5

   Ax         1         0         0        0        0
   Bx         0         0         1        0        0
   Cx         0         0         0        0        1
   Dx         0         0         0        1        0
   Ex         0         1         0        0        0

Answer 1

select customerid, 
    case when status = 1 then 1 else 0 end as status_1,
    case when status = 2 then 1 else 0 end as status_2,
    case when status = 3 then 1 else 0 end as status_3,
    case when status = 4 then 1 else 0 end as status_4,
    case when status = 5 then 1 else 0 end as status_5
from your_table
order by customerid;