Augustabc的博客

原创 mysql计算同比环比

sql 计算同比环比 – 同比 SELECT t1.now_year AS 年份, t1.now_month AS 月份, CASE WHEN now_month_num IS NULL OR now_month_num = 0 THEN 0 ELSE now_month_num END 本月销售量, CASE WHEN last_month_num IS NULL OR last_month_num = 0 THEN 0 ELSE last_month_num END 去年同期销售量, CASE WHEN