SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL listagg with distinct

user9311128Apr 6 2021

Hi,
I need to build a select query that concatenates the unique values and distinct the duplicate values in a column. Can anyone help please?
I tried with listagg, concatenates well but not able to distinct.
Data Source:
Data Output Expected:

Thank you

This post has been answered by Frank Kulash on Apr 6 2021

Jump to Answer

Added on Apr 6 2021

#plsql, #sql

4 comments

1,912 views

1 mention