pv2为参数,接收具体年份,例如2023select t.*from(SELECT lpad(t.month,2,0) as FMONTH, t.month || '月实际产量' as MONTHVIEWFROM(select level month from dual connect by LEVEL<13)t)twhere (1=1) ${if(pv2 = to_char(SYSDATE,'yyyy'),"AND t.FMONTH<= SUBSTR(to_char(SYSDATE,'yyyy-mm'),6,2)","")}