案例:

   Map<String,Object> queryAgricultureTotal();

<select id="queryAgricultureTotal" resultType="java.util.HashMap">
        SELECT sum(CASE WHEN type_name LIKE '%合作社%' THEN 1 ELSE 0 END) AS hezuoshe,
               sum(CASE WHEN type_name LIKE '%家庭农场%' THEN 1 ELSE 0 END) AS familyFarm,
               sum(CASE WHEN type_name LIKE '%种植企业%' THEN 1 ELSE 0 END) AS plantCompany,
               (SELECT count(1) AS counts FROM pf_company_info WHERE delete_flag = 0 AND cate_one = 5) AS allCount
        FROM pf_company_info
        WHERE delete_flag = 0
          AND cate_one = 5
    </select>

最后你利用map.get(key)就可以获取到你统计的值