'Selecting name from aggregated ID in Postgresql
I have no clue how to do this.
(Select Dane1.Name, Array_agg(Dane1.UpperCat) as "upper_category", count(Dane1.UpperCat) As data_count, dane1.room_id
From
(Select
contact.room_id,
UpperCategory_Id As "UpperCat", /* uppper category ID of rooms */
Rooms.Name As "Name",
Rooms.Type
From Public.contact
Join Rooms On contact.room_id= Rooms.Rooms_Id) As Dane1
Group by Dane1.Name, Dane1.UpperCat,dane1.room_id)
Result:
| Name | upper_category | data_count | room_id |
|---|---|---|---|
| Room 1 | {25,25,25,25} | 4 | 150 |
The goal is to count how many times the upper category occurs AND what's the name of said category.
It's all in Rooms table but I can't get that, only sub room ID's name. I don't care about {25,25,25,25} but the name that corresponds to that ID in the aggregate function.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
