sql语句查询同比、环比
sql语句查询同比增量、同比同比增量SELECTa.customer,a.month,( a.x - b.y ) 同比增量FROM( SELECT customer, year, month, SUM(number) x FROM syxy_sales WHERE year = 2020 GROUP BY month,customer ) aLEFT JOIN ( SELECT customer, year, month, SUM(number) y FROM syxy_sales WHER
原创
2021-01-21 18:30:48 ·
4617 阅读 ·
0 评论