小Y(提问者)select sn from cus_mis_clickpad_mac_all where csdate between to_date(\'${begintime} 00:00:01\',\'yyyy/mm/dd hh24:mi:ss\')
and to_date(\'${endtime} 23:59:59\',\'yyyy/mm/dd hh24:mi:ss\') and machine_name=\'曲线检测\' and sn=\'${序号}\'
大师,我看不太懂你说的,我贴出了sql
地球刘亦菲 回复 小Y(提问者)select sn from cus_mis_clickpad_mac_all where csdate between to_date(\\\'${begintime} 00:00:01\\\',\\\'yyyy/mm/dd hh24:mi:ss\\\') and to_date(\\\'${endtime} 23:59:59\\\',\\\'yyyy/mm/dd hh24:mi:ss\\\') and machine_name=\\\'曲线检测\\\'
${if(len(sn) == 0,\"\",\"and sn in (\'\" + 序号+ \"\')\")}