mybatis .xml SQL count(1) 和SUM函数的简单使用
数据库MySQL代码示例:problemMapper.xml<select id="qureyProblemCount" resultType="java.util.HashMap"> SELECT COUNT(1) AS totalCount, SUM (CASE WHEN PROBLEM_LEVEL='1' THEN 1 ELSE 0 END) AS aCount, S