SELECT a.*,b.pro_amo as 年初,c.pro_amo as 年末 FROM tablea a

left join (

select * from tablea where substr(pro_date,6,2)='01'

) b on substr(a.pro_date,1,4)=substr(b.pro_date,1,4)

left join (

select * from tablea where substr(pro_date,6,2)='12'

) c on substr(a.pro_date,1,4)=substr(c.pro_date,1,4)-1

把字段格式化一下，然后匹配即可

TO_CHAR(CURRENT_DATE,'YYYY-MM')

https://www.cnblogs.com/yuan88008/p/15597988.html

SELECT (TRUNC(SYSDATE,'YYYY')-INTERVAL '1' YEAR) 上年年初,(TRUNC(SYSDATE,'YYYY')-INTERVAL '1' DAY)上年年末 FROM dual

--sysdate 改为你自己的日期字段就行了