根据ID合并两行

本文介绍了根据ID合并两行的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有带有选择，选择ID和问题ID之类的字段的表. 现在，我想将与一个问题相关的选择合并到一个语句中，然后插入第二个表中. 对于前 choiceId choiceName问题ID 1个1 2 b 2 questionId选择 1〜1〜2〜 我该怎么办?

I have table with fields like choices ,choice Id and question Id. Now i want to join this choices which are associated to a question into a single statement and insert into the second table. for ex choiceId choiceName questionId 1 a 1 2 b 2 questionId choices 1 ~1~2~ How can i do it ?

推荐答案

请通过此链接 sqlyoga/2009/02/sql-server-get- comma-separated-list.html Please go through this link sqlyoga/2009/02/sql-server-get-comma-separated-list.html