WHERE C.codepath LIKE '${banshichu}%' AND m.YEARMONTH = '${YEARMONTH}' OR m.YEARMONTH = '${YEARMONTH,-1}'
这个去年同期,应该怎么写,帆软会认到,求助!
WHERE C.codepath LIKE '${banshichu}%' AND m.YEARMONTH = '${YEARMONTH}' OR m.YEARMONTH = '${CONCATENATE(left(YEARMONTH,4)-1,MID(YEARMONTH,5,3))}'