finereport 怎么写SQL自动查询数据库中近7天的数据? 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这么写,无法识别,请打什么指点下 |