SQL (postgres) show group by aggregation in different columns like a matrix

Asked Apr 25 '19 at 10:46

Active Apr 25 '19 at 10:51

Viewed 34 times

I have a query where I am trying to find the count of values for 2 parameters. Let's say for this example that I have a set of people, I record the eye colour and hair colour for each person.

So I now want to see a distribution of how many people exist for each set of eye colour and hair colours. Simple I can run

select eye, hair, count(*) from people
group by eye, hair

But this returns a table with two columns. What I would like is to see is a matrix format where the first column shows the eye colour, then each next column represents an hair colour and the value is the count of individuals with the hair and eye colour.

Is there a way to do this?

edited Apr 25 '19 at 10:51

asked Apr 25 '19 at 10:46

Charlie

You need a pivot table operation https://stackoverflow.com/questions/20618323/create-a-pivot-table-with-postgresql – Roman-Stop RU aggression in UA Apr 25 '19 at 10:48
1

Possible duplicate of [Create a pivot table with PostgreSQL](https://stackoverflow.com/questions/20618323/create-a-pivot-table-with-postgresql) – Roman-Stop RU aggression in UA Apr 25 '19 at 10:49

SQL (postgres) show group by aggregation in different columns like a matrix

0 Answers0