我有這個查詢結果：
| Activity | Player |
| ----------- | --------- |
| Play Tennis | John Doe |
| Play Tennis | Jane Doe |
| Play Bowling | Jonah Doe |
但目標應該是這樣的：
| Activity | Player |
| ----------- | ------------------- |
| Play Tennis | John Doe |
| | Jane Doe |
| Play Bowling | Jonah Doe |
或像這樣：
| Activity | Player |
| ----------- | ------------------- |
| Play Tennis | John Doe, Jane Doe |
| Play Bowling | Jonah Doe |
如何實作該查詢？
我想在這里分享我當前的查詢和完整的專欄，但由于作業場所的嚴格規定，我不能（我希望每個人都能理解）
謝謝。
uj5u.com熱心網友回復：
對于第二種格式，您可以使用GROUP_COUNCAT()：
SELECT Activity, GROUP_CONCAT(Player) AS Player
FROM table_name
GROUP BY Activity
小提琴
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/406044.html
標籤：