SELECT AVG(字段) from table where to_char(时间段,'yyyymmdd') between (SELECT to_char(add_months(sysdate,-1),'yyyymmdd') FROM dual) and to_char(sysdate,'yyyymmdd');
SELECT AVG(字段) from table where to_char(时间段,'yyyymmdd') between (SELECT to_char(add_months(sysdate,-1),'yyyymmdd') FROM dual) and to_char(sysdate,'yyyymmdd'); 很对!!
from table
where to_char(时间段,'yyyymmdd') between (SELECT to_char(add_months(sysdate,-1),'yyyymmdd') FROM dual) and to_char(sysdate,'yyyymmdd');
from table
where to_char(时间段,'yyyymmdd') between (SELECT to_char(add_months(sysdate,-1),'yyyymmdd') FROM dual) and to_char(sysdate,'yyyymmdd');
很对!!