Stack Overflow Asked on January 3, 2022
I have records like this after applying joins
id name item
1 bil Books
2 mike Table
2 mike chair
3 josh pen
3 josh pencil
4 peter copy
But, I want them to look like this
id name item
1 bil Books
2 mike Table,chair
3 josh pen, pencil
4 peter copy
How to achieve this?
Use group by
and group_concat()
:
select id, name, group_concat(item) items
from mytable
group by id, name
Answered by GMB on January 3, 2022
0 Asked on August 6, 2020 by lan
1 Asked on August 5, 2020 by webelf000
2 Asked on August 5, 2020 by sheraram_prajapat
1 Asked on August 4, 2020 by ivan-g
1 Asked on August 4, 2020 by jonboy
1 Asked on August 2, 2020 by rakesh
1 Asked on August 2, 2020
2 Asked on August 2, 2020 by phil
1 Asked on August 2, 2020 by jonathan-rauscher
0 Asked on August 1, 2020 by fredirty2017
0 Asked on August 1, 2020 by visionary_20
1 Asked on August 1, 2020 by ignacio-gomez
1 Asked on July 31, 2020 by mandroid
2 Asked on July 31, 2020 by virendra-varma
2 Asked on July 30, 2020 by podoi17
functional programming java 8 method reference mockito spring
0 Asked on July 29, 2020 by jare42
Get help from others!
Recent Answers
Recent Questions
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP