Mybatischoosewhen用法实例代码

    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})