如何在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 有一个非常规范的列表 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.

这篇关于如何在Oracle中检索A、B格式的两列数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！