select SA.DN_BRAND_FLG,SUBSTR(LPAD(SA.SPLIT,1,2),1,2) ||'00' ,SA.DN_PIP_ID from SYS_ACDGROUP SA
group by SA.DN_BRAND_FLG,SUBSTR(LPAD(SA.SPLIT,1,2),1,2) ||'00',SA.DN_PIP_ID
以上SQL正确;
select SA.DN_BRAND_FLG,sum(SA.SPLIT),SA.DN_PIP_ID from SYS_ACDGROUP SA
group by SA.DN_BRAND_FLG,2,SA.DN_PIP_ID
以上SQL正确;
select SA.DN_BRAND_FLG,SUBSTR(LPAD(SA.SPLIT,1,2),1,2) ||'00' ,SA.DN_PIP_ID from SYS_ACDGROUP SA
group by SA.DN_BRAND_FLG,2,SA.DN_PIP_ID
以上SQL执行错误。