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