如何在Oracle中检索A、B格式的两列数据
我在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 有一个非常规范的列表 Oracle 中的字符串聚合技术.
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.
相关文章