如何排序由 XMLAGG 函数聚合的字段? [英] How to order the fields getting aggregated by XMLAGG function?

问题描述

我有下表:

Part_number   seq_nbr    Super_narrative
1                1        When replacing
1                2        part  with following parts
1                3        note:follwing are now available
1                4        with the organization 

我正在使用 XMLAGG 将 super_narrative 聚合在与 part_number 对应的 1 行中.

I am using the XMLAGG to aggregate the super_narrative in 1 line corresponding to part_number.

SELECT serv_part_nbr, rtrim (xmlagg (xmlelement (e, Super_narrative || ', ')).extract ('//text()'), ',') PHRASE_TEXT 
FROM BL_MACS_SUPERSEDENCE_NOTE
GROUP BY part_number

但我想根据seq_nbr聚合super_narrative.

怎么做??

推荐答案

你没有提到 DBMS，但一个大胆的猜测是:

You don't mention DBMS, but a wild guess would be:

SELECT serv_part_nbr
              , rtrim (xmlagg (xmlelement(e, Super_narrative || ', ') order by seq_nbr ).extract ('//text()'), ','
                          ) PHRASE_TEXT 
 FROM BL_MACS_SUPERSEDENCE_NOTE
 GROUP BY part_number

这篇关于如何排序由 XMLAGG 函数聚合的字段?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！