select '本月',a.值 from ( select by_income as 值 from app_db.vacompany_m_hy where calmonth = translate(substr(current_date() , 1 ,7 ),'-','') ) as a 这是取本月的数据,请问我想改成取最近六个月的数据,应该怎么写呢? |
最佳回答 |
||||
0
|
|