oracle 数据查询

1,读取从今天到1个月前之间的数据
select * from table
where column between add_months(sysdate, -1) and sysdate;