一列变三列的例子：
select
max(case rownumber % 3 when 2 then id else null end) as id1,
max(case rownumber % 3 when 2 then [text] else null end) as text1,
max(case rownumber % 3 when 1 then id else null end) as id2,
max(case rownumber % 3 when 1 then [text] else null end) as text2,
max(case rownumber % 3 when 0 then id else null end) as id3,
max(case rownumber % 3 when 0 then [text] else null end) as text3
from
(select row_number() over(order by [type] desc) as rownumber,[id],[text] from tablename) A
group by (rownumber+2)/3
本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。
