mysql计算同比环比
sql 计算同比环比– 同比SELECTt1.now_year AS 年份,t1.now_month AS 月份,CASEWHEN now_month_num IS NULLOR now_month_num = 0 THEN0 ELSE now_month_numEND 本月销售量,CASEWHEN last_month_num IS NULLOR last_month_num = 0 THEN0 ELSE last_month_numEND 去年同期销售量,CASEWHEN
原创
2020-05-21 20:50:11 ·
837 阅读 ·
0 评论