sql—将多行数据串联在一行中，并用逗号分隔

xn1cxnb4 于 2021-07-24 发布在 Java

关注(0)|答案(1)|浏览(274)

我有一个表，我想合并相同的问题，他们的答案。这个问题的答案需要用逗号隔开

tbl_data
Userid       question           answer      email
1032         Marital status     Single      Something@something.com
1032         Requirements       eco house   Something@something.com
1032         Requirements       garage      Something@something.com
1032         requirements       garden      Something@something.com
1032         Household income?  over 80k    Something@something.com
1033         Martial status     Married     harry@something.com

我想查看这样的数据，并结合要求的问题和答案

tbl_data
    Userid       question           answer                    email
    1032         Marital status     Single                    Something@something.com
    1032         Requirements       eco house,garage,garden   Something@something.com
    1032         Household income?  over 80k                  Something@something.com
    1033         Martial status     Married                   harry@something.com

我在这里尝试了这个解决方案，但没有任何运气，因为它只是将所有问题的答案添加到每个尝试解决方案的答案中

sql sql-server-2008 string-concatenation

来源：https://stackoverflow.com/questions/63018443/concatenate-mutiple-row-data-in-one-row-seperated-by-comma

1条答案

按热度按时间

eivnm1vs1#

SELECT Userid, GROUP_CONCAT(question SEPARATOR ',') as questions, answer, email FROM tbl_data GROUP BY question;

赞(0）回复(0）举报 2021-07-24

我来回答

sql—将多行数据串联在一行中，并用逗号分隔

1条答案

相关问题

热门标签

最新问答