select h.pro_amo-h.上年末 as a,

          (h.pro_amo-h.上年末)/h.上年末 as b

from H

where h.pro_amo is not null and h.上年末 is not null

这样不行？

再 外面套一层select呗

-------------

这种应该不用套了

with H as(

select F.PRO_DATE,

       F.PRO_NAME,

       F.PRO_AMO,

       lag(pro_amo, 3, null) over(order by pro_name ) as 上年末

from FR_202203Last3YSKDC_TABLE F

)

select *，pro_amo-上年末，（pro_amo-上年末）/上年末

from H

where h.pro_amo is not null and h.上年末 is not null

with H as(

select F.PRO_DATE,

       F.PRO_NAME,

       F.PRO_AMO,

       lag(pro_amo, 3, null) over(order by pro_name ) as 上年末

from FR_202203Last3YSKDC_TABLE F

)

select 

*,

NVL(PRO_AMO, 0)-NVL(上年末, 0) as A,

CASE WHEN NVL(上年末, 0) = 0 THEN 0 ELSE (NVL(PRO_AMO, 0)-NVL(上年末, 0)) / 上年末 END as B

from H

where h.pro_amo is not null and h.上年末 is not null

防止除数为0