sql - 将多行数据连接在一行中，以逗号分隔

Question

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

tbl_data
Userid       question           answer      email
1032         Marital status     Single      [e-mail]
1032         Requirements       eco house   [e-mail]
1032         Requirements       garage      [e-mail]
1032         requirements       garden      [e-mail]
1032         Household income?  over 80k    [e-mail]
1033         Martial status     Married     [e-mail]

我想这样查看数据并结合需求问答

tbl_data
    Userid       question           answer                    email
    1032         Marital status     Single                    [e-mail]
    1032         Requirements       eco house,garage,garden   [e-mail]
    1032         Household income?  over 80k                  [e-mail]
    1033         Martial status     Married                   [e-mail]

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

标签： sqlsql-server-2008string-concatenation

Answer 1

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