Question

oracle取昨天记录

需求有特定环境，例如 select val from tableA where dtm between A AND B;这个SQL如果取上个月，可以 select val from tableA where add_month(dtm,1) between A AND B;但如果是日偏移，如何实现？只能去处理dtm字段，between后的语句不允许修改

Answer 1

select count(*) from 表名 partition 分区名;

Answer 2

select val from tableA where (dtm-1) between A AND B;
这样写试一下，看看是否好用。