query case when postgresql

Question

I have query like this :

select
    case when code=31 then name end as name1,
    case when code=32 then name end as name2
from master where code=31 or partner_id=32

and the result just like this :

I want to make just 1 row but 2 column which is the value is like the table above.

Anyone can help me? Thanks

Gordon Linoff · Accepted Answer · 2017-05-17 02:43:34Z

1

Use aggregation:

select max(case when code=31 then name end) as name1,
       max(case when code=32 then name end) as name2
from master
where code = 31 or partner_id = 32;

answered May 17, 2017 at 2:43

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

query case when postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related