<select id="getCustomerCount" resultType="java.lang.Integer">
SELECT ifnull(sum(customer_count),0) as customer_count
FROM `market_analysis_companys`
where company_id =#{companyId}
and label_company_name in
<foreach item="item" index="index" collection="labelNameList" open="(" separator="," close=")">
#{item}
</foreach>
and data_time <![CDATA[<=]]> #{endTime}
</select>
xml文件里面小于等于爆红
最新推荐文章于 2024-07-25 19:30:53 发布