查询多个count展示结果
<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>
---------------------------------------------------------------------------
国之殇,未敢忘!
南京大屠杀!
731部队!
以及核污染水排海等一系列全无人性的操作,购买他们的食品和为它们提供帮助只会更加变本加厉的害你,呼吁大家不要购买日本相关产品
昭昭前事,惕惕后人
吾辈当自强,方使国不受他人之侮!
---------------------------------------------------------------------------
作者:三号小玩家
出处:https://www.cnblogs.com/q1359720840/
版权声明:本作品采用知识共享署名-非商业性使用-禁止演绎 2.5 中国大陆许可协议进行许可。 版权信息