Questions tagged [listagg]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
195 views

Remove/distinct duplicates on listagg - oracle

I'm using the oracle-xe 11g version and I have the below sql code that I aggregation the course code, but the output has duplicates. SELECT b.alu_cpf AS login, b.alu_nomeco ...
0
votes
0answers
316 views

Removing Duplicates in LISTAGG

In the query below, I used the LISTAGG function to aggregate certificate names I.e. JPM_DESCR90 . However , now I'm trying to find a way to remove all the duplications in the row, and reducing the ...
2
votes
3answers
993 views

De-Duplicate from LISTAGG

I am using 11.2 version of oracle. I want to de-duplicate from LISTAGG. below is existing data in oracle db: Speaker | Qualification | Product P A P1 P B ...
1
vote
1answer
139 views

listagg in order and including a sequence of separator when missing any row of a sequence

Sorry for the long title but it's a little bit difficult to explain. We have a table | N rows | Atrib1 | Atrib2 | Atrib3 | Atrib4 | Final row | --------------------------------------------------...
2
votes
0answers
4k views

“result of string concatenation is too long”

I have a query which uses listagg it is as follows SELECT listagg(path1.PATHWAY_ID,'|like||id|')within GROUP ( ORDER BY path1.PATHWAY_ID), listagg(path1.PATHWAY_NAME,'|like||name|') within GROUP ( ...
0
votes
1answer
309 views

Concatenate Data from different row from same table

This is SQL source Table. I need to concatenate this table like the table below,appreciate your help. PE_CASE PE_ITEM PE_HIS_SEQ PE_COMMENT 200 0001 9989 Comment 1 200 ...