SELECT SUM(CASE WHEN A = REPLACE(DATE_SUB(CURRENT_DATE(),1),'-','') THEN B END) 值1 ,SUM(CASE WHEN A = TO_CHAR(DATE_SUB(CURRENT_DATE(),1),'YYYYMMDD') THEN B END) 值2 FROM TABLES
结果 :值1=0,值2=3
SELECT CASE WHEN A = REPLACE(DATE_SUB(CURRENT_DATE(),1),'-','') THEN B END 值1 ,CASE WHEN A = TO_CHAR(DATE_SUB(CURRENT_DATE(),1),'YYYYMMDD') THEN B END 值2 FROM TABLES