随笔分类 -  SQL

摘要：SELECT B.resultNo,resultList as result FROM (SELECT resultNo,(SELECT CONVERT(nvarchar, questionnaireNo)+CONVERT(nvarchar, highestQuestionNo) FROM ResultAnalyze WHERE resultNo=A.resultNo ORDER BY questionnaireNo FOR XML PATH('')) AS resultListFROM ResultAnalyze A GROUP BY resultNo) B查询代码 阅读全文