Skip to Main Content

SQL & PL/SQL

How do i display multiple rows as One Row by Eliminating Duplicates among them

1651695May 16 2014 — edited May 16 2014

How do I display multiple rows data as one Row? And also eliminate any duplicates among them..

For Example

Column1              Column2

A0                       JAN, FEB, MAR, SEP

B0                       JAN, FEB

C0                       JUN, JUL, AUG, SEP, OCT, NOV, DEC

My Output should be

COLUMN2

JAN,FEB,MAR,SEP,JUN,JUL,AUG,OCT,NOV,DEC

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2014
Added on May 16 2014
9 comments
3,354 views