I want to select a column "B" as a list when it's column "A" is the same

Question

I want to select column "B" as a list when it's column "A" is the same. Say I have:

A                | B 
-----------------------------------
10000            | 5000         
10000            | 5000         
10001            | 9090        
10002            | 9090         
10000            | 9090

As a result, I would like to have:

A                | B 
-----------------------------------
10000            | '5000,5000,9090'               
10001            | '9090'        
10002            | '9090'

How should I go about this? Thanks all!

8.4 is no longer maintained. You should _really_ upgrade to a supported version — , Apr 27 '15 at 09:51
Hi, @a_horse_with_no_name. Unfortunately, it's not up to me to decide. :( — Kevin, Apr 27 '15 at 13:21

score 0 · Accepted Answer · edited May 23 '17 at 11:43

0

You can try this

select A, array_to_string( array_agg("B"), ' , ') from tablename GROUP BY A order by A

for more reference visit this

edited May 23 '17 at 11:43

Community

1
1

answered Apr 27 '15 at 09:33

Mani Deep

1,298
2
17
33

I want to select a column "B" as a list when it's column "A" is the same

1 Answers1