select
*
from LG_GNLKXX_TEMP
where
delete_state =0 and (RZLX = 0 or RZLX = 1)
and create_date >= to_date(to_char(sysdate-10/(24*60),'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')
and create_date <= to_date(to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')