如何使用 LISTAGG 返回以引号为前缀的行 [英] How to use LISTAGG to return rows prefixed with quotes

问题描述

我正在尝试返回对在查询中设置 in 条件有用的行.这是我的查询

I am trying to return rows which would be useful for setting the in condition in a query. Here is my query

SELECT LISTAGG(PRODUCTID, ',') WITHIN GROUP (ORDER BY RowSequence) FROM DWRE_ITEM_V

返回 Order1,Order2

which return Order1,Order2

我希望它返回 'Order1','Order2'

I would like it to return 'Order1','Order2'

我尝试使用 concat 运算符 ||没有运气.

I tried using the concat operator || with no luck.

推荐答案

SELECT LISTAGG(''''||PRODUCTID||'''', ',') WITHIN GROUP (ORDER BY RowSequence) 
FROM DWRE_ITEM_V

这篇关于如何使用 LISTAGG 返回以引号为前缀的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！