select * from a
where s_09 = '80084752-d79b-4972-ad5e-2c29fea67d16'
and s_16 <> 'R'
and s_08 between to_date(to_char(sysdate-10,'yyyy/mm/dd'),'yyyy/mm/dd') and to_date(to_char(sysdate+1,'yyyy/mm/dd'),'yyyy/mm/dd')
oracle 查询前10天到后一天的数据
最新推荐文章于 2024-06-21 11:12:18 发布