我是新的SQL,我试图使一个递归查询工作在PostreSQL没有任何运气。
我有一个表tb_invoice,其中有这些列:
<表类>
invoice_no
cust_no
或
tot_amount
tbody><<tr>"F0000C000400200" "C0004" "Y" 28786.7 "F0000C000400201"> "C0004" "N" 5624.29 "F0000C000400202"> "C0004" "Y" 25675.54 "F0000C000400203"> "C0004" "Y" 35479.72 "F0000C000400207"> "C0004" "Y" 23497.47 "F0000C000500212"> "C0005" "N" 14754.03 "F0000C000500213"> "C0005" "N" 3073.5 表类>
使用STRING_AGG
函数创建逗号分隔的发票列表
SELECT
cust_no,
STRING_AGG(invoice_no,',' ORDER BY invoice_no) invoice_list
FROM tb_invoice
WHERE payed = 'N'
AND tot_amount > 28000
GROUP BY cust_no;