- 同一张表中,统计不同条件下多个字段值
- 代码
<select id="getSomeData" parameterType="string" resultType="map">
SELECT
COUNT(CASE
WHEN CC_DD_ZT = '0004010101' THEN
1
END) SLSL,
COUNT(CASE
WHEN CC_DD_ZT = '0004010109' THEN
1
END) CXSL
FROM
表名 t
WHERE
t.CC_SLRGH = #{workNum} AND substr(t.CC_SLSJ,0,8) = to_char(sysdate,'yyyymmdd')
</select>