listagg within group

Listagg WITHIN GROUP是Oracle数据库的一个函数，用于将多行数据合并成一行，并通过指定的分隔符进行分割。它的语法是：

SELECT listagg(column_name, 'delimiter') WITHIN GROUP (ORDER BY column_name) alias
FROM table_name
GROUP BY column_name;

其中，column_name是要合并的列名，delimiter是分隔符，alias是合并后的列的别名。该函数首先根据ORDER BY子句对数据进行排序，然后将排序后的值按照指定的分隔符进行拼接。这样可以将多个行的数据合并成一行，并以指定的方式进行分割。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [oracle的 listagg() WITHIN GROUP () 行转列函数的使用](https://blog.csdn.net/sinat_36257389/article/details/81004843)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *2* [Oracle函数之LISTAGG](https://download.csdn.net/download/weixin_38743391/13689936)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *3* [oracle的 listagg() WITHIN GROUP () 函数使用](https://blog.csdn.net/tnb_ml/article/details/122669392)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 33.333333333333336%"]
[ .reference_list ]