22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT [name],
c1=CASE sn WHEN 1 THEN 1 ELSE 0 end,
c2=CASE sn WHEN 2 THEN 1 ELSE 0 end,
c3=CASE sn WHEN 3 THEN 1 ELSE 0 end,
c4=CASE sn WHEN 4 THEN 1 ELSE 0 end,
c5=CASE sn WHEN 5 THEN 1 ELSE 0 end,
c6=CASE sn WHEN 6 THEN 1 ELSE 0 end,
c7=CASE sn WHEN 7 THEN 1 ELSE 0 end
from (select row_number() over (partition by [Name],c1,c2,c3,c4,c5,c6,c7 order by [Name]) as sn, * from tb) as a