Question

i have the sql code that returns the result

Set1   Value
A       A1      
A       A2
A       A3
A       A4

如何显示类似结果

Set1    Value1      Value2       Value3      Value4
A           A1        A2           A3          A4

增编

Answer 1

考虑这一点

页: 1 服务器:PIVOTing String data

Answer 2

接下来是trick。使用<代码>ROW_NUMBER 允许除<代码>A1外的数值。

SQL Statement

SELECT  [Set1] = Set1
        , [Value1] = MIN(CASE WHEN rn = 1 THEN Value END)
        , [Value2] = MIN(CASE WHEN rn = 2 THEN Value END)
        , [Value3] = MIN(CASE WHEN rn = 3 THEN Value END)
        , [Value4] = MIN(CASE WHEN rn = 4 THEN Value END)
FROM    (       
            SELECT  Set1
                    , Value
                    , rn = ROW_NUMBER() OVER (PARTITION BY Set1 ORDER BY Value)
            FROM    AResult
        ) q
GROUP BY
        Set1

SQL Statement

友情链接