如何在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的

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格式的两列数据

相关推荐