数据表如下table:
table
A B
101 2015
102 2013
103 2014
104 2015
105 2012
106 2016
查询出来的数据应该如下(字段B每两行合并):
A B
101 2015 2013
102
103 2014 2015
104
105 2012 2016
106
不知道是否有解?
------解决思路----------------------
;WITH CTE AS(
SELECT A,B
,ROW_NUMBER()OVER(ORDER BY GETDATE())RN
FROM [table]
)
SELECT T1.A,CASE WHEN T1.RN%2=1 THEN T1.B+' '+ISNULL(T2.B,'')ELSE''END
FROM CTE T1
LEFT JOIN CTE T2 ON T1.RN=T2.RN-1 AND T1.RN%2=1