I am having data like this by using this query Now, I want to show data like this and so on..I also know it can achieve by GROUP_CONCAT function. So, I tried with this But, It shows me error. So, what I am doing wrong here. What are the right procedure to achieve that? Answer You need to add GROUP
Tag: group-concat
Using COUNT in GROUP_CONCAT
This is my table: id | fk_company ——————- 1 | 2 2 | 2 3 | 2 4 | 4 5 | 4 6 | 11 7 | 11 8 | 11 …
Join one row to multiple rows in another table
I have a table to entities (lets call them people) and properties (one person can have an arbitrary number of properties). Ex: People Properties I would like to write an efficient select that would select people based on age and return all or some of their properties. It’s also acceptable to return one …