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 of the properties and total property count.