sql多行合并

（sqlserver可以用，其他未试）

SELECT
    qqo.questionID '题目id',
    qqo.quesOption '选项'
FROM   qz_question_option qqo,
       qz_question qq
WHERE qqo.questionID = qq.questionID

上面多行记录合并为如下形式：

SELECT
    qq.questionID '题目id',
    (SELECT
       qqo.quesOption + '  |  '
    FROM qz_question_option qqo
    WHERE qqo.questionID = qq.questionID AND qqo.valid = 1
    FOR xml PATH (''))
    AS '选项'
FROM qz_question qq

 

 

转载于:https://www.cnblogs.com/whatarewords/p/10712027.html