mybatis choose when的用法实现代码如下所示:
mapper.xml:
select
a.city_id as CITYID,
a.level1_maintain_unit_id as CITYID,
a.county_id as CITYID,
sum(ONUNUM) as ONUNUM,
sum(ONTNUM) as ONTNUM
from new_olt_upopt_sp_month_${tableDate} a
where 1 = 1
and a.city_id = '0001'
= ${startDate}]]>
group by
a.city_id
a.level1_maintain_unit_id
a.county_id
having a.county_id in
(select city_id from tab_city
where city_id= #{cityId} or parent_id=#{cityId})
以上所述是小编给大家介绍的Mybatis choose when用法实例代码,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对脚本之家网站的支持!