Mybatis杂记
group by查询返回map类型 1,2
List<Map<String, Object>> getCount();
xml:
<select id="getCount" resultType="java.util.HashMap">SELECT company_id, ifnull(sum(count_a + count_b),0) ctFROM test.com_countWHERE `is_del`= 0 GROUP BY company_id having ct > 0
</select>
返回数据示例：
[{"company_id": "id1","ct": 10},{"company_id": "id2","ct": 12},...
]
https://blog.csdn.net/fgszdgbzdb/article/details/78017486 ↩︎
https://blog.csdn.net/weixin_44339331/article/details/105232544 ↩︎