查询时间前一年的数据

  SELECT ADD_MONTHS(sysdate, -12) AS "当前时间减一年" FROM dual;

 SELECT ADD_MONTHS(to_date('2016-02-09','yyyy-mm-dd'), -12) AS "指定时间减一年" FROM dual;