sql server 中把多行数据显示为一行

--转化为xml格式,去掉根节点,形成一行
--select ','+(field009)+'-'+(field010) from ufv2m7k41656039640871 where field007<0 order by field010 asc for xml path('')
select STUFF((select ','+(field009)+'-'+(field010) from ufv2m7k41656039640871 where field007<0 order by field010 desc), 1, 1, ' ')

posted @ 2022-07-30 19:51  java璀璨小菜鸟  阅读(530)  评论(0)    收藏  举报