I have a data result from a view like below,
But I want a view like this
Can any one help me to do this via postgresql without using extensions.
2
-
1Please go through all the questions for pivot or crosstabuser330315– user3303152019-12-11 07:52:18 +00:00Commented Dec 11, 2019 at 7:52
-
1This is typically much better done in the application, than in SQLuser330315– user3303152019-12-11 07:53:11 +00:00Commented Dec 11, 2019 at 7:53
Add a comment
|
1 Answer
use aggregation
select project, max(case when role='owner' then name end) as owner,
max(case when role='client' then name end) as client,
max(case when role='Team' then name end) as Team
from table
group by project;
Alternatively you can use the filter() clause which makes this a bit easier to read:
select project,
max(name) filter (where role='owner') as owner,
max(name) filter (where role='client') as client,
max(name) filter (where role='Team') as Team
from table
group by project;
answered Dec 11, 2019 at 7:51
Zaynul Abadin Tuhin
32.1k6 gold badges38 silver badges67 bronze badges
Comments
