select calmonth as '月份',by_income as '本月收入',tq_income as '同期收入',tb_income_rate as '收入同比',hb_income_rate as '收入环比' from app_db.yw_m where calmonth =translate(substr(current_date() , 1 ,7),'-','') 现在是只取本月的数,我想改成取本年所有月的数据,应该怎么改呢? |
最佳回答 |
||||
1
|
|