目前我只会查询一个周之内的数据(定值),但是我想要查到当周往前推两周往后推九周的数据,这该怎么写?SELECT
a.DIVISION_NAME,
e.fmweek,
COUNT (a.CUSTOMER_DEMAND_DATE) 按期交付个数
FROM
WR_OPC_investment_info c INNER JOIN WR_OPC_Pre_investment_info b ON
b.PROJECT_NO = c.PROJECT_NO
INNER JOIN WR_OPC_Forecast_info a ON b.OPPORTUNITY_NO = a.OPPORTUNITY_NO
INNER JOIN MDM_DIVISION d ON a.DIVISION_NO=d.DIVISION_NO
INNER JOIN MDM_TIME e ON a.CUSTOMER_DEMAND_DATE=e.fdate
WHERE
to_char(a.CUSTOMER_DEMAND_DATE,'yyyyMM') = '202010'--月份
and e.fmweek ='2020101' --2020十月第一周
and ((C.ACTUAL_END_DATE is not NUll ) OR (C.PLAN_END_DATE is not NUll ))
AND to_char(C.ACTUAL_END_DATE,'yyyyMMdd') <= to_char(A.CUSTOMER_DEMAND_DATE,'yyyyMMdd')
GROUP BY a.DIVISION_NAME,e.fmweek ORDER BY e.fmweek
因为往后推九周是没有数据的,得查其他的三张表