如何在Oracle中检索A,B格式的两列数据 [英] How to retrieve two columns data in A,B format in Oracle
问题描述
我在Oracle数据库中有两列
I have two columns in oracle database
+---------+---------+
| Column1 | Column2 |
+---------+---------+
| A | 1 |
| A | 2 |
+---------+---------+
我想检索数据,就像我将获得结果一样
I want to retireive the data like i will get data as result
+---------+---------+
| Column1 | Column2 |
+---------+---------+
| A | 1,2 |
+---------+---------+
请向我提供解决方案.
推荐答案
Tim Hall has a pretty canonical list of string aggregation techniques in Oracle.
您使用哪种技术取决于许多因素,包括Oracle的版本以及您是否正在寻找纯SQL解决方案.如果您使用的是Oracle 11.2,则可能建议使用LISTAGG
Which technique you use depends on a number of factors including the version of Oracle and whether you are looking for a purely SQL solution. If you are using Oracle 11.2, I'd probably suggest using LISTAGG
SELECT column1, listagg( column2, ',' ) WITHIN GROUP( order by column2 )
FROM table_name
GROUP BY column1
如果您使用的是Oracle的早期版本,则假设您不需要纯粹的SQL解决方案,我通常会更喜欢使用
If you are using an earlier version of Oracle, assuming you don't need a purely SQL solution, I would generally prefer using the user-defined aggregate function approach.
这篇关于如何在Oracle中检索A,B格式的两列数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!