sql语句查询同比增量、同比
SELECT
a.customer,
a.month,
( a.x - b.y ) 同比增量,
( a.x - b.y ) / b.y * 100 同比
FROM
( SELECT customer, year, month, SUM( number ) x FROM syxy_sales WHERE year = 2020 GROUP BY month, customer ) a
LEFT JOIN ( SELECT customer, year, month, SUM( number ) y FROM syxy_sales WHERE year = 2019 GROUP BY month, customer ) b ON a.month = b.month
GROUP BY
a.customer
sql语句查询环比增量、同比
SELECT
a.customer,
a.month,
( a.x - b.y ) 环比增量 ,
( a.x - b.y ) / b.y 环比
FROM
( SELECT customer, month, SUM( number ) x FROM syxy_sales WHERE year = 2019 GROUP BY month, customer ) a
LEFT JOIN ( SELECT customer, month, SUM( number ) y FROM syxy_sales WHERE year = 2019 GROUP BY month, customer )