Skip to content

convert column in rows and get count of different values of same column in postresql

test convert column in rows and get count of different values of same column in postresql

Advertisement

Answer

You can do conditional aggregation. Postgres supports the standard filter() clause, that comes handy here:

User contributions licensed under: CC BY-SA
7 People found this is helpful