SELECT${if(type=="1"," 字段A * 10 ")} as 字段别名,AMT,WT,PRICEFROM 表名如果传的type参数等于1，就让这个字段乘以10SELECT A."YMON",A."wt",${if(type=="1"," A."wt" * 10 "," A."wt" ")} AS "wt2",FROM (SELECT LEFT(CUR_DAY,6) AS "YMON",DECIMAL(ROUND(SUM(DISTINCT DAY_OUTPUT_WT),1),12,1) AS "wt"FROM BGTMMAKS01.T_ADS_SRV_KSCB_DAY_COSTWHERE (LEFT(CUR_DAY,6) BETWEEN '202311' AND '202311' OR LEFT(CUR_DAY,6) BETWEEN '202312' AND '202312')AND COST_CENTER IN ('ABB0','ABJ0')GROUP BY LEFT(CUR_DAY,6)) AS A----------------${if(type=="1"," A.wt * 10 "," A.wt ")} AS "wt2",
