SELECT * FROM "WIP"."PARAMETRIC_MEASURE"
where
measure_name in('THICK_DIFF_FAE_REDGE5','THICK_DIFF_FAE_REDGE7','THICK_DIFF_FAE_REDGE10')and test_date_time between date_sub(curdate(),interval 7 day) and curdate();--date_sub(curdate(),interval 7 day) SQL这么写,无法识别,请打什么指点下