SELECT top 2000 freevalueid,
max(case when assindex=0 then freevalueid else '' end) a,
max(case when assindex=1 then freevalueid else '' end) b,
max(case when assindex=2 then freevalueid else '' end) c
from gl_freevalue
GROUP BY freevalueid
ASSINDE 只有3 个值 0 1 2
我用case when 试了,SELECT top 2000 freevalueid,
case when assindex=0 then freevalueid else '' end a,
case when assindex=1 then freevalueid else '' end b,
case when assindex=2 then freevalueid else '' end c
from gl_freevalue
GROUP BY freevalueid, assindex
得到的却是