查询多个count展示结果

转载于 2019-06-12 11:17:00 发布 · 87 阅读

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/q1359720840/p/11008463.html

本文展示了一段SQL查询代码，用于从客户记录数据中统计不同类型（D、I、S、C）的喜欢和不喜欢的数量。通过左连接操作，代码能够有效地区分每个类型下喜欢（content='1'）和不喜欢（content='0'）的数量。

    <select id="getCountByDISC" resultType="com.rm.algo.entity.AlgoResult">
SELECT
sum( case when t2.type='D' and content='0' then 1 else 0 end) as unlikeD,
sum( case when t2.type='I' and content='0' then 1 else 0 end) as unlikeI,
sum( case when t2.type='S' and content='0' then 1 else 0 end) as unlikeS,
sum( case when t2.type='C' and content='0' then 1 else 0 end) as unlikeC,
sum( case when t2.type='D' and content='1' then 1 else 0 end) as likenessD,
sum( case when t2.type='I' and content='1' then 1 else 0 end) as likenessI,
sum( case when t2.type='S' and content='1' then 1 else 0 end) as likenessS,
sum( case when t2.type='C' and content='1' then 1 else 0 end) as likenessC
FROM cust_record_data  t1 left  JOIN cust_qn_option t2  ON  t1.option_id=t2.id  WHERE
t1.validate_flag="Y" AND t2.validate_flag="Y" AND t1.qn_id=#{param1} AND t1.`status`=1
    </select>

转载于:https://www.cnblogs.com/q1359720840/p/11008463.html