oracle sql根据条件连接2列

ddrv8njm 于 2021-07-24 发布在 Java

关注(0)|答案(1)|浏览(390)

假设我有一张table：

+----+------------+------------+
| ID |   NAME1    |     NAME2  |
+----+------------+------------+
| A1 |    DAVE    |    DAN     |
| A1 |    DOR     |    MON     |
| A2 |    STEPHAN |    ARKEL   |
| A3 |    ASH     |    CATCHAM |
| A4 |    RON     |    DON     |
| A4 |    OFIR    |    DOL     |
| A4 |    OFRA    |    SOL     |
+----+------------+------------+

我想根据id连接，如果下一行具有相同的id，则添加两个名称，如下所示：

+----+-----------------------------------+
| ID |             NEW_NAME              |
+----+-----------------------------------+
| A1 |    DAVE~~DAN^^DOR~~MON            |
| A2 |    STEPHAN~~ARKEL                 |
| A3 |    ASH~~CATCHAM                   |
| A4 |    RON~~DON^^OFIR~~DOL^^OFRA~~SOL |
+----+-----------------------------------+

谢谢。

sql oracle string-concatenation

来源：https://stackoverflow.com/questions/62741616/oracle-sql-concatenate-2-columns-based-on-condition

1条答案

按热度按时间

ax6ht2ek1#

你可以做：

select
  id,
  listagg(name1 || '~~' || name2, '^^') 
    within group (order by name1, name2) as new_name
from t
group by id

请参见在sql<>fiddle上运行示例。

赞(0）回复(0）举报 2021-07-24

我来回答

oracle sql根据条件连接2列

1条答案

相关问题

热门标签

最新问答