SELECT SUBSTR( date_time, 0, 8 ) date_time, cx, cx_name, cx_code, SUM ( total_num ) num FROM dm.dm_mk_pf_passenger_flow A left JOIN dm.dm_mk_dim_car_type C ON A.cx = C.cx_code WHERE SUBSTR( date_time, 0, 5 ) = '2021' ${if(len('CX5','CX30')=0,"","and cx_code in('"+ 'CX5','CX30'+ "')")} GROUP BY SUBSTR( date_time, 0, 8 ), cx, cx_name, cx_code -------------'CX5','CX30'-------------------这个为车系参数 请问各位大佬,红色部分为我复选框选择 两项的参数 ,这个sql是错误的,配置分隔符了 已经蒙圈了 |