Transact SQL查询-枢轴-SQL

Transact SQL查询-枢轴-SQL

;WITH cte     AS (SELECt SeekId,     CatId,     ct.Name,     ROW_NUMBER() OVER (PARTITION BY SeekId ORDER BY CatId) AS RN         FROM   MySeekCatTable sk     JOIN CatTable ct       ON sk.CatId = ct.CatId)SELECt SeekId,       MAX(CASE WHEN RN = 1 THEN Name END) AS A,       MAX(CASE WHEN RN = 2 THEN Name END) AS B,       MAX(CASE WHEN RN = 3 THEN Name END) AS CFROM   cteGROUP  BY SeekId