oracle查询按月分组后,历史月份中存在使用数量超过前一个月使用数量120%的数据
<if test="isNotify != null and months.size() > 1">
HAVING
<foreach collection="months" item="month" separator="or" index="index">
<if test="index != 0">
SUM(CASE WHEN to_char(ecd.xx_time,'yyyyMM') = ${months[index]} THEN ecd.goods_qty ELSE 0 END) >
SUM(CASE WHEN to_char(ecd.xx_time,'yyyyMM') = ${months[index - 1]} THEN ecd.goods_qty ELSE 0 END) * 1.2
</if>
</foreach>
</if>