postgreSql数据库，同一字段拼接成字符串

最新推荐文章于 2025-02-21 01:21:37 发布

wangfangxu17

最新推荐文章于 2025-02-21 01:21:37 发布

阅读量3.3k

点赞数

分类专栏： PostgreSql 文章标签：数据库

本文链接：https://blog.youkuaiyun.com/wangfangxu17/article/details/84662024

版权

PostgreSql 专栏收录该内容

1 篇文章

订阅专栏

select DISTINCT(a.orderid), array_to_string(array(SELECT opinion from tsac_worklist), '-->') as opinion
from tsac_worklist a where orderid='402881634848bb1a014848c002110006'

另外，在sql中添加换行符，在要显示的内容后面拼接|| CHR(10) || CHR(13)则可以换行，chr(10)是换行，chr(13)是回车。
select DISTINCT(a.orderid), array_to_string(array(SELECT opinion||';'|| CHR(10) || CHR(13) from tsac_worklist
where orderid in (select m.id from tsac_orderinfo m where m.ordercode = 'GD20140926001572') ORDER BY recievetime asc limit 100 OFFSET 1), '') as opinion
from tsac_worklist a where a.orderid in (select m.id from tsac_orderinfo m where m.ordercode = 'GD20140926001572')