sql查询同一员工、同一供应商、同一产品，连续两月及两月以上存在差异信息数据

WITH M AS
 (SELECT L.UNIQ_NO, L.PROD_ID, L.ORD_RECE_SUPP_ID, L.BUSI_YM
    FROM CS_BACK_IMPORT_PROBLEM_REL L
    JOIN ES_EMP_INFO O
      ON L.UNIQ_NO = O.UNIQ_NO
   WHERE 1 = 1
     AND L.IS_ERROR = 1
     AND L.WHETHER_EFFECTIVE = 1)
SELECT DISTINCT M.UNIQ_NO, M.BUSI_YM, M.ORD_RECE_SUPP_ID, M.PROD_ID
  FROM M
  JOIN M N
    ON (((M.BUSI_YM + 1) = N.BUSI_YM OR ((M.BUSI_YM - 1) = N.BUSI_YM)) AND
       M.UNIQ_NO = N.UNIQ_NO AND M.PROD_ID = N.PROD_ID AND
       M.ORD_RECE_SUPP_ID = N.ORD_RECE_SUPP_ID)