SELECT ${if(type=="1"," 字段A * 10 ")} as 字段别名, AMT, WT, PRICE FROM 表名 如果传的type参数等于1，就让这个字段乘以10 SELECT 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_COST WHERE (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", |
1min目标场景问卷
立即参与
