sql之多数据字段值拼接以及去重_sql server 字符 去重 连建

1、使用场景

今天用到多数据拼接字段的方法，不会用sql做，特此记录。

2、sql语句

  <select id="queryCaseInfoDetails" resultType="com.iflytek.sf.zlfy.model.vo.SettlementVo">
        select c.case_order_no        as caseOrderNo,
               c.case_type            as caseType,
               c.receive_file_time    as receiveFileTime,
               c.deadline_time        as closeTime,
               c.case_status          as caseStatus,
        ( SELECT GROUP_CONCAT( a.applicant_name ORDER BY a.sort ) AS applicantName FROM t_applicant_info a WHERE
        a.case_order_no = c.case_order_no ) AS applicantName,
        ( SELECT GROUP_CONCAT( r.respondent_name ORDER BY r.sort ) AS respondentNames FROM t_respondent_info r WHERE
        r.case_order_no = c.case_order_no ) AS respondentName,
               0                      as seekReviewDocument,
               0                      as isPublishOpinionDoc,
               0                      as isPublishProposalDoc,
               ad.apply_type          as applyType,
               ad.behavior_type       as behaviorType,
               ad.administrative_type as administrativeType
        from t_case_info c
                 left join t_case_apply_detail ad on c.case_order_no = ad.case_order_no
        where c.case_order_no = #{caseOrderNo,jdbcType=VARCHAR}
        group by  c.case_order_no
    </select>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21