怎么取得上月的今天的日期和去年的今天的日期最方便？
------解决方案--------------------
select add_month(sysdate,-1) from dual 上月的今天
------解决方案--------------------
select add_months(sysdate,-1) from dual
select add_months(sysdate,-12) from dual
------解决方案--------------------
- SQL code
select * from ( select a.*,rownum rn from a where id in('a','b','c') and date <=to_date('2008-07-02','yyyy-mm-dd') order by date desc) where rn <=3