MySQL 常用

/**

1.上一期+1个月和当前期不相等，同时排除还款日是当月的最后1天
2.还有待还款的数据

*/

SELECT  b.loan_id,a.periods AS p_p,b.periods AS c_p,c.`PERIODS` AS n_p,a.predict_repayment_date AS pre_date,b.predict_repayment_date AS this_date,c.`PREDICT_REPAYMENT_DATE` AS next_date
FROM t_loan_repayment_history a,t_loan_repayment_history b ,t_loan_repayment_history c 
WHERE a.loan_real_id = c.loan_real_id
AND   b.loan_real_id = c.loan_real_id
AND a.periods = b.periods - 1 
AND   b.periods = c.`PERIODS` -1   
AND 
(
  DATE_ADD(a.predict_repayment_date,INTERVAL 1 MONTH) <> b.predict_repayment_date
  OR
  DATE_ADD(b.predict_repayment_date,INTERVAL 1 MONTH) <> c.predict_repayment_date
)
AND (LAST_DAY(a.predict_repayment_date) <>  a.predict_repayment_date)
AND (LAST_DAY(b.predict_repayment_date) <>  b.predict_repayment_date)
AND (LAST_DAY(c.predict_repayment_date) <>  c.predict_repayment_date)

AND a.repayment_time IS NULL
ORDER BY loan_id ,a.`PERIODS`