mysql滑动订单问题

SELECT
    DATE_FORMAT(a.ordermonth, ‘%Y%m‘) AS frommonth,
    DATE_FORMAT(b.ordermonth, ‘%Y%m‘) AS tomonth,
    SUM(c.ordernum) AS orders
FROM monthlyorders a
INNER JOIN monthlyorders b 
    ON DATE_ADD(a.ordermonth, INTERVAL 2 MONTH) = b.ordermonth
    AND MONTH(a.ordermonth) % 3 = 1
INNER JOIN monthlyorders c
    ON c.ordermonth BETWEEN a.ordermonth AND b.ordermonth
GROUP BY a.ordermonth,b.ordermonth;

mysql滑动订单问题

标签：